Viewing 15 posts - 12,976 through 12,990 (of 14,953 total)
I agree that you are probably running into a compile error on this one.
What I'm wondering, though, is why do you need this code in the first place? It...
July 3, 2008 at 12:13 pm
Are the transactions being tracked by a trigger? If so, is it set up correctly to deal with multi-row inserts/updates?
Is it possible to delete a voucher? If so,...
July 3, 2008 at 12:08 pm
The Output clause selects data. A trigger shouldn't do that. Output Into will store the data in a separate table, a temp table, or a table variable.
What are...
July 3, 2008 at 12:05 pm
That kind of defeats the whole purpose of using stored procedures.
What I think you're looking for is software that will generate on-the-fly SQL code for you. There are several...
July 3, 2008 at 12:02 pm
rashmi.todkar (7/3/2008)
I tried to use CTE here but how to specify a specific depth in CTE query. In a heirarchy of depth 6 if i...
July 3, 2008 at 11:58 am
You might be better off using the Import Wizard in Management Studio. Right-click on the database you want to insert the data into, then Tasks, Import Data, and walk...
July 3, 2008 at 11:49 am
In the data flow task, there are options to split data, add derived columns, etc. I think those are what you need.
July 3, 2008 at 11:47 am
Try moving it to a staging table on the 2005 server, then moving it to the partitioned table.
July 3, 2008 at 11:45 am
Microsoft has a log file reader that's currently free. It's on their web site. Allows you to query the files as if they were SQL tables. Check...
July 3, 2008 at 11:44 am
I think certificates and degrees have a monetary value, in that they can result in getting hired when all other things are equal, and can even result in higher starting...
July 3, 2008 at 11:42 am
You can't have the Use and the command to use in separate exec() commands. Returns the scope to the calling script/proc once the first command is done.
And, for this...
July 3, 2008 at 11:29 am
Michael Valentine Jones (7/2/2008)
jsheldon (7/2/2008)
I didn't give very detailed variable...
July 3, 2008 at 11:26 am
Jeff Moden (7/2/2008)
GSquared (7/2/2008)
cast a curse of impotence on the original coder and all his descendants for a thousand generationsUmmmm... isn't THAT a bit of an oxymoron? 😀
Didn't say it...
July 3, 2008 at 11:13 am
Only thing I can think of is that I have had to re-create some database level user-accounts after migrating from 2000 to 2005. If you've handled that, I'm stumped...
July 3, 2008 at 11:11 am
Simon Facer (7/3/2008)
So, it still comes down to the right technology in the right circumstance, you just need to know the different behaviours and...
July 3, 2008 at 11:09 am
Viewing 15 posts - 12,976 through 12,990 (of 14,953 total)