You still have not said what you want to do about...

Right, that's what I was talking about. And what do...

Use '%@A %' instead of '%@A%'. (There's a space after the A in the first one)

rahulsony111 (10/14/2009)

---

Thanks for taking interest in my problem

Those identity columns are already been set. I dont have an option to change them.

All i have to do is to create a...

Oops, just noticed PP posted the same thing :Wow:

So you're basically looking for column level dependencies. In 2000, I don't think you're going to find anything. Someone might have a script that'd get you closer than...

And if you don't specifically need this to be a script, just hit F4 in your query analyzer to do an object search. If I didn't need my F4...

Michael Valentine Jones (10/13/2009)

---

GSquared (10/13/2009)

---

I'd say go ahead and include them. It means a little extra RAM being allocated, but it doesn't hurt anything beyond that.

It allows the dev...

Jonathan Melo (10/14/2009)

---

The example values are for a single employee, in the end I'll have to handle multiple employees, but I figure if I can get something working with a...

OK, I think I see part of it. The 8462.57 value is creating its own line because it is the 7th value (zeroes not counted apparently) in the row...

:blink: :blink: :blink: Uhh... Huh? :ermm: :ermm: :ermm:

In either case, the solution is to add a new record and copy the rest of the...

OK, I knew this looked familiar. I see from your other thread that you are very new. Please explain as best you can, why you think you need...

Is there a reason you need that column to be an identity column at all? If you're using it as an identity column for other things, and just manually...

Or check out the Crosstabs / Pivots link in my signature.

If bob's solution doesn't work, can't you just join invoice to your CTE and use RowNumber in your case statements instead of the variables you're assigning now? No access...