I have the following code. I would like to group on Month and year. I have tried converting datetime to varchar to change the format.That did not work. Running the...

I am a developer, but even if I weren't my opinion about the urgency of these questions still stands.

Understand, I am not saying the OP doesn't have a right to...

Your way would definitely save a few CPU cycles, but shouldn't it be

GROUP BY DATEADD(month,datediff(month,0,cv.Dischargedtm),0)

??

European or African swallow?

GROUP BY convert(varchar(6),getdate(),112)

I believe this is the third question which I have seen marked "urgent" from this particular OP.

Obviously, it's all urgent to him. But...

Because his homework assignment is due in the morning?

The Thread is like a Zen koan.

Why was this urgent?

Gail is right. However neither cubes nor summary tables in SQL get automatically updated when values are changed. You have to rebuild them. ...

If the data is static, just take the results of the query and store them in a table, then query THAT table.

First, test performance by writing to a temp table, not displaying on a screen. Screen display of thousands of rows adds overhead that has nothing to do...

I have to ask: Why is this being done with a cursor? It is terribly inefficient, as is populating each variable with a separate query to the...

You're welcome, Mike.

Mark, the articles are very worthwhile and you will find tally tables an enormously useful (and FAST) technique. Take the...

Mark, it's time you learned about tally tables to replace while loops and save a few cpu cycles. 🙂

Some good articles

http://www.sqlservercentral.com/articles/T-SQL/62867/

http://www.sqlservercentral.com/articles/T-SQL/67899/

An example for parsing:

declare @input varchar(100)

set @input = '|1|2|3|a|b|c|delta|bravo|#|@|'

;with...