David Burrows (2/25/2009)

---

I belive it was changed in SP2.

Right click on...

Sunil Kumar (2/25/2009)

---

Hi There,

Here is my query....I am getting Daily Sum of MINUTS.

I would likt to make it as Monthly Sum if possible.

SELECT CONVERT(VARCHAR,[Date],105) as DATE,

...

Ashwin M N (2/25/2009)

---

The Detail_ID is in sorted order by Inventory_Code and Detail_Date.

Why is that when I pass a parameter(Inventory_Code) values are updated correctly? If it was not sorted...

Thanks folks... darned thing isn't there for me.

Is it actually a table... or is it actually a view?

I'm using 2k5 at sp2... and there's no "Summary" selection in the "View" menu... has anyone actually tried this?

Pretty much. Some folks actually use it to get around "parameter sniffing" problems.

First of all, the reason why your code turned back into a slow monster is because you used a While Loop... AGAIN! If you're gonna keep doing that to...

Ross McMicken (2/25/2009)

---

It might be easier to take the code from sp_who2 and change it to generate the desired data directly. I did a modified version a couple of years...

The problem with even some small scale concatenation is... people abuse it and don't know what it actually does to the server. Sure, "It Depends"... but few take the...

Test data...

DROP TABLE JBMTest

GO

--===== Create and populate a 1,000,000 row test table.

-- Column "RowNum" has a range of 1 to 1,000,000 unique numbers

...

Thanks Jack... lotta tension on this side, lately, and I had to make sure I wasn't tuggin' on a friend's chain.

Jack Corbett (2/24/2009)

---

Ah yes, this is one of those tools I need to remember. I don't have to deal with updates like this that often so I always forget...

Oh yeah... almost forgot... the big reason why I wanted to know what the OP was going to do with the string aggregates is that a lot of people think...

Bob Hovious (2/23/2009)

---

Also, I think you missed the point about compression.

If I return 1000 rows that read

John|Smith|1,2,3 (assume...