Only when he gets on his high horse 😉

btw Jeff, excellent article, as always 😀

Only the Best eh :hehe:

Wow! Are the number of QOTD replies getter longer or what :w00t:

There seem to be a lot of strong personalities here :crazy:

Glad I'm not a DBA....

always right, never wrong and...

Way... way... too much information Jeff :sick:

No but I'll have one for each working day though :w00t:

... I'd like to work with you...

BULK INSERT / BCP will not truncate/remove trailing spaces on input data, and since you already stated that the data contains trailing spaces and is longer than the column definitions...

At the moment the issue is that it places the data in the wrong columns leaving blank columns. The data seems to be ok. It seems like it doesnt like...

I belive you are looking for a PIVOT like this

SELECT[ID],

MAX(CASE WHEN IDX = 0 THEN APP_DEGREE_ID ELSE null END) AS [Degree0],

MAX(CASE WHEN IDX = 1 THEN APP_DEGREE_ID ELSE...

ORDER BY applies to the result of the UNION not the individual SELECT's so you can do this

SELECT 1 AS [Result]

UNION

SELECT 2 AS [Result]

ORDER BY Result DESC...

The question indicates a file not a database, don't know is this makes a difference :unsure:

OK. I'll go to the bottom of the nerd's class 🙁

See if this works better

There are locations (Dealers) that represent a Car Dealership that sells cars. The code for the...

No need Jeff 🙂

Not me... but...

Sorry Jeff...

Did not know if you were laughing at me :crying:

or at my question 🙁

or was it that I actually posted one :blink:

Sorry Ron. I'll try to meke it clearer :blush:

Thanks for the reply 🙂

The data is separate by Location, ie the ContactID will unique...

Good spot Sergiy 🙂

Maybe this instead then

SET @sql = 'select * from [' + REPLACE(REPLACE(@dbname,'[',''),']','') + '].dbo.tblAccounts where [date]=''09/04/1998'''

EXECUTE(@sql)

btw your sql would not work anyway, it is...

Do you mean like this (for your original query)

EXECUTE('select * from [' + @dbname + '].dbo.tblAccounts where [date]=''09/04/1998''')

Note the number of single quotes