Jeff Moden (1/23/2009)

---

Matt Miller (1/23/2009)

---

As for me, I would settle for actual, complete, documentation of the new features added as they are added. Functionality changes, "this doesn't work in...

I'd look at the BCP utility, which would give you a LOT of options as to how to output the query.

As for me, I would settle for actual, complete, documentation of the new features added as they are added. Functionality changes, "this doesn't work in x version anymore", some...

Jeff Moden (1/23/2009)

---

I'll add another wish... there's a lot of things (not just running totals) that require "looking" at a range of previous or next rows. It would be...

Jack Corbett (1/22/2009)

---

K. Brian Kelley (1/22/2009)

---

If I'm a...

you need a comma where you put that space, i.e.

DATEADD(dd,-1 , getdate())

you're not correlating the two sets or orderlines, which is why you're getting more rows than expected. Unless you have a one-to-one correlation between OL and OL1, there's no...

Grant Fritchey (1/22/2009)

---

DBADave (1/22/2009)

---

Let's see how you like this one. I just spoke with a technical contact for the vendor regarding various topics and on the subject of enabling...

I'm assuming you're now talking about datalength....

OPENROWSET needs to be allowed through on 2005 and later. You access that through the SQL Server Surface area config tool.

Lynn Pettis (1/21/2009)

---

Dennis D. Allen (1/21/2009)

---

Greetings Lynn,

Yes that does work and is a fine workaround.

I want to understand why this does not work as it should work correctly...

David Webb (1/21/2009)

---

Lynn,

I've been following the other thread mentioned above. Based on the expected outcome he just posted (which had exactly 0 relation to the sample data provided), if...

Agreed. On small sets - it's sometimes faster to just do the insert first, but by far and large - it's better not to do the update on the...

Without details, it's hard to say whether you're right or not. There are times where it does help to prepopulate, especially in a reporting scenario like you have.

That...

The only way you're going to ENSURE that it's unique is to keep track of all of the ones previously generated. Use whatever methodology you like to gen it,...