you could replace the IF statement with

SELECT pKey, Column1 INTO #Tmp1 FROM Items

WHERE (<condition1> AND <condition2> ) OR

(<condition1> AND <condition3> )

Carlos' method is probably the quickest but you could create a CREAT TABLE script

In SSMS right click on the table > Script Table as.. > Create To..

You can then...

please stop cross posting, you are wasting our precious clicks

what is the pattern of the characters i.e.

12GGG23 or

GGG151516H or

11111JJJJJ or ...

you could develop a .net assembly that reads the excel file, link it to a table valued function which you would use in you script. i am thinking you can...

are you saying you managed to successfully use SQL Authentication?

Is the SQL user that is logged have access to the sql server?

you can assign the string to another variable which you then add it to your final variable

set @details =   SELECT 'FileNumber = '+...

for the sake of arguing with you John, Magy did not explicitly specify that she was looking getting opinions on writing style, hence there are more than one solutions to...