I have a strong feeling we're missing...

Without the rest of your code, it's hard to say for sure what all problems you might have, but I'm guessing that your @AchieveLevel variable is an int. If so,...

Possible, yes. Recommended, not in my book. In fact, unless you come up with a VERY good reason for this, I can't in good conscience tell you how to do...

Glad that it worked for you, Marcus, and Jeff was spot on that the easier it is for us to help you, the more likely we are to do so.

For...

This should work with your sample data. You get to add the rest of the columns from the two main tables to the select, as I'm lazy, in case you...

Jeff Moden (12/18/2007)

---

David,

Now, be gentle with me... just now starting to get my feet wet on 2k5... 😉

...since the following two queries return the identical result set, why did you...

Since you're using 2005, you might try this method (I stole the table variable code from Adam Haines, since I'm lazy), tweaking it as needed:

declare @tbl1 table(id int,descr varchar(25))

declare @tbl2...

Depending on your environment, that solution may or may not be acceptable. By default, I don't think the surface area configurator is going to allow the openrowset shown above, although...

While I didn't test this, so there may be other issues, lose the comma on the line before the LOG ON line.

While you should have gotten an error, I'm not sure why it was a syntax error. SELECT INTO won't work because it's a loop, so on the second pass, it...

Since there are several places that it could have been turned on, why not verify that that is your problem first?

I'd just add a SET IMPLICIT_TRANSACTIONS OFF to the code...

For a quick and dirty solution, you can just make a copy of that system stored proc (carefully, as you don't want to overwrite existing system stored procs if you...

I was going to respond in the other thread, but since it's in the Data Corruption forum for some reason, I'll toss it in here. If you'd rather not use...

While you can also do it pretty easily with CASE statements, you can also add a Replace function to goodguy's code and handle the blank lines in a single row,...

Jeff Moden (11/6/2007)

---

Heh... no question that with that many rows of data that you need to do some data marting and that you're not actually trying to create reports from...