Mate, post your table structures (CREATE TABLE statements), Some sample data (INSERT INTO script), Indexes and Constraints if any and your expected result based on the sample data. THis will...

LOL 😀

Hi there, this is the working version of the code.. please ignore the code present in the post above

BUT BEFORE U MOVE ONTO THE CODE, I WOULD SUGGEST U READ...

Will this help you?

I am writing this code from my home where i have no access to SQL Server. once i reach office i will check the validity of that...

yes, as vyas pointed out, use BCP.. very fast utility to bulk insert millions of rows..

David, that was not my requirement, the OP has asked for it 🙂 i tried my level best to produce a result without case and dynamic sql 🙂

Oh man, i very nearly pulled this thing out without CASE and DYNAMIC-SQL...

here is the code; if in future u are planning to append many extra columns, say e,f,g...

Is your .Net Code executing the .sql thro sqlcmd/isql or is it reading the whole database creation query into a string and then executing the string using ExecuteQuery ?

Hmmm..

Tel me if u did this:

1. You Right-click on the database, "Create To" to a new SQL Server Window

2. SAve this script as .sql file

3. And now u are trying...

For SQL Server 2005, the compatiblity level can maximum be 90 and there is no command like HONOR_BROKER_PRIORITY

I tried this code in both SQL 2005 and 2008. i got error...

One doubt mate, are u trying to run this piece of code in SSMS 2005 or SSMS 2008?

Mate, are u sure we have instr function in SQL Server ? :blink: :blink:

I agree with Lynn here... CASE statements look appropriate here and to my knowledge readable too, then why would you prefer dynamic SQL??

here is a sample code with CASE statement...

I always ask people to look up to your post on forum etiquettes Jeff.. i will add that to my signature as well 🙂

Exactly Jeff!!

When the OP is unclear then we are explicitly type-casted to be unclear 😀 :w00t: