Didn't realize we could sue other members' stored procedures 😉 Just an attempt to pump some humor, Lowell. No offense meant. 🙂

-...

I don't think this is doable in SQL just by replacing a simple function/format for the blanks. From a cursory look, it appears more to be in MYSQL format, which...

Chris,

Attached is a document with screenshots describing how to script all SPs from a database into individual files.

- Rex

You are using the same file name for 'NG_System_Data', 'NG_Core_Data_1' and 'NG_Index_1'. Try moving them to different files and it should work.

- Rex

Depends on the type of activity from A to B and vice-verse. Are there going to be distributed transactions involved? More details of the nature of usage will help in...

I can't do that, unfortunately.

-Rex

I try to use "|" as column separator. It will be a much more cleaner option, if you can have your source text file generated this way.

- Rex

That's pretty neat. Thanks for sharing the solution.

- Rex

Seems quite interesting. Could you provide the following additional info?

What is the from date for a term?

How do you account for fractions? In other words, if a student missed a...

Instead of 1 thru 10, try numbering them 0 thru 9.

- Rex

Did you increase the column lengths to a bigger number in your new table? If this didn't help, get a bit innovative and try to load one column at a...

Typically you would encounter this error when there is an attempt to insert data that is larger than the column can take. For e.g., if you have a "CompanyName" column...

Hello All,

Thanks a lot to everyone that replied with detailed inputs and suggestions to help me find a solution. I really appreciate your help.

Sincerely,

Rex

It all depends on the date range a given user selects for the report. Since data is avaialble for about 10 years, in theory it could vary from 1 to...

Vijay,

Since your current identity value is less than the current column value, there is a good possibility that the trigger is trying to insert a value that already exists for...