Viewing 15 posts - 46 through 60 (of 62 total)
Lowell (4/4/2013)
....see how i modified it to sue sp_msForEachDb,....
Didn't realize we could sue other members' stored procedures 😉 Just an attempt to pump some humor, Lowell. No offense meant. 🙂
-...
April 4, 2013 at 11:18 am
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...
April 4, 2013 at 11:08 am
Chris,
Attached is a document with screenshots describing how to script all SPs from a database into individual files.
- Rex
April 3, 2013 at 11:34 am
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
April 3, 2013 at 11:01 am
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...
April 3, 2013 at 10:55 am
I can't do that, unfortunately.
-Rex
April 3, 2013 at 10:07 am
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
April 2, 2013 at 3:13 pm
That's pretty neat. Thanks for sharing the solution.
- Rex
April 2, 2013 at 12:50 pm
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...
April 2, 2013 at 12:48 pm
Instead of 1 thru 10, try numbering them 0 thru 9.
- Rex
April 2, 2013 at 12:14 pm
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...
April 2, 2013 at 11:59 am
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...
April 2, 2013 at 11:50 am
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
April 17, 2012 at 9:32 am
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...
December 2, 2011 at 7:33 pm
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...
November 2, 2011 at 3:07 pm
Viewing 15 posts - 46 through 60 (of 62 total)