Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @CollationName varchar(50)
- set @CollationName = (
- select collation_name
- from information_schema.columns
- where table_name = 'MeteringPointPrice' and column_name = 'MeteringPointId'
- )
- if OBJECT_ID('tempdb..#MPLIST2') IS NOT NULL
- drop table #MPLIST2
- if @CollationName = 'SQL_Danish_Pref_CP1_CI_AS'
- create table #MPLIST2 (MeteringPointId varchar(18) COLLATE SQL_Danish_Pref_CP1_CI_AS)
- if @CollationName = 'Danish_Norwegian_CI_AS'
- create table #MPLIST2(MeteringPointId varchar(18) COLLATE Danish_Norwegian_CI_AS)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement