In this example, I group by the first day of the month, order by that value, and extract year and month from that value.

select

[Year]= year(dateadd(mm,datediff(mm,0,Mydate),0)),

MonthName= datename(month,dateadd(mm,datediff(mm,0,Mydate),0)),

[RowCount]= count(*)

from

( -- Random Test...

I became a DBA when I was older than you, and I'm somehow managing to get by.

There are projects that are so mismanaged that they become a death march that...

524,258 terabytes

Let us know if that limit becomes a problem.

It would by handy if SQL Server had an enhanced IsNumeric function that you could pass a specific target data type to, but that's the way it is for now.

Are you asking for help optimizing code you did not post?

The first condition will allow use of an index on the Date_Column, and the second will compare the combined date and time columns to 24 hours before current time for...

Joe Celko (7/22/2010)

---

Actually, using the proprietary MONEY is a huge problem. It does not divide or multiply correctly. It does...

Adam Haines (7/21/2010)

---

No need for a computer column here. You should use the like operator.

DECLARE @t TABLE(

col VARCHAR(10)

);

INSERT INTO @t VALUES ('13abc');

INSERT INTO @t VALUES ('1abcde');

SELECT *

FROM @t

where col...

TravisDBA (7/21/2010)

---

Really? I find that...

PaulB-TheOneAndOnly (7/20/2010)

---

Yes indeed but - always a "but" huh? - the other "more complex" way is...

Vaghasiya Nilesh (7/19/2010)

---

Thank u guys...

and one more thing my week is strat from saturday to friday

and im enter today's date that giving me output will be like this:

(dd/mm/yyyy)

10/7/2010 -...

Wouldn't this be a simpler calculation?

COST = [Total Pageviews] * 0.000005

Sounds like no one read his follow-up post on the blog:

"...However, in this case we had been on a couple calls with EMC about this and even had their top...

select

a.DT,

Date_Only = dateadd(dd,datediff(dd,0,a.DT),0),

Time_Only = a.DT-dateadd(dd,datediff(dd,0,a.DT),0)

from

( -- Test Data

select DT = convert(datetime,'1753-01-01 00:00:00.003')

union all

select DT = convert(datetime,'1753-01-01 07:21:09.997')

union all

select DT = convert(datetime,'1753-01-01 23:59:59.997')

union all

select DT = getdate()

union all

select DT =...

If you have another server available that is running a 32-bit OS, you could schedule jobs that require 32-bit ODBC drivers to run on that server.