Using just LF as a record delimiter did the trick. A quick internet search confirmed that LF was a standard on UNIX, and this is certainly simpler than doing...

honza.mf (9/17/2010)

---

tommyh (9/16/2010)

---

Nice question. Though the explanation isnt entirely accurate. Its not rounded, its truncated.

If the question had been, lets say

declare @r decimal(5,2)

set @r= round(5/3.2,1,3)

select @r

Then we...

danajao (9/7/2010)

---

Thanks for a very interesting tip ... problem I have though is while my expression provides me with a previous date ... it fails when moving into another month...

Here's another little script to demonstrate the effect of using float. Although the local variable looks pretty good out of a simple "print @i", converting the value to decimal...

Here one question comes in the mind that why only one row is indicated by 1? The Scheme_Total and Product_Total is also aggregated but it is not indicated by 1....

witasj,

I see the same contents in @Grouptest as you do.

It looks as though the loaded table shown in the article may not be from the final version of...

Gosh, I hope I don't get my shoes wet by stepping near this, but.....

The original script in the article absolutely needs an ORDER BY to properly interleave...

Sankar Reddy (7/14/2010)

---

[font="Courier New"]Going thru the comments, it seems NOT everyone is aware that NOT NULL clause is necessary when altering the column. It’s a simple fact but not everyone...

Wow. Did I mess up on this one. Let me correct myself before someone else has to.

The answer to Sunil's question about why only the grand total line...

Adam Haines (7/12/2010)

---

I personally think the reason the function returns null is because of NULL concatenation math. I think the underlying code uses loops and concatentates the string piece...

Actually, I think the answer to that would go back to the...

I cannot answer that authoritatively, but consider that it would make no...

Richard Tatterton (6/25/2010)

---

Adam Haines (6/25/2010)

---

While this is true.... a string is a string, but the deviation here is the method used to evaluate the strings. Part of the ANSI...

I'll bet you'd...

Lynn Pettis (6/24/2010)

---

SanjayAttray (6/24/2010)

---

Even though I got it right and know its possible but when executed in SSMS 2005 it returned error.

Msg 139, Level 15, State 1, Line 0

Cannot assign...