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...

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,...

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...

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...

rashmi.todkar (7/3/2008)

---

hey all thanks for your replies.

I tried to use CTE here but how to specify a specific depth in CTE query. In a heirarchy of depth 6 if i...

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...

In the data flow task, there are options to split data, add derived columns, etc. I think those are what you need.

Try moving it to a staging table on the 2005 server, then moving it to the partitioned table.

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...

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...

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...

Michael Valentine Jones (7/2/2008)

---

jsheldon (7/2/2008)

---

Neither could I, I know it is within the ALTER TABLE command and that's what I put as my answer

I didn't give very detailed variable...

Didn't say it...

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...

Simon Facer (7/3/2008)

---

GSquared / Lynn, thanks for your insights.

So, it still comes down to the right technology in the right circumstance, you just need to know the different behaviours and...