Tom.Thomson (10/15/2010)

---

Do you...

selectDaysTillChristmas =

datediff(dd,getdate(),dateadd(yy,datediff(yy,-1,getdate()),-7))

Results:

DaysTillChristmas

-----------------

71

Note: This will always give you Dec 25 for the...

Time in job does not mean knowledgble. I interviewed a DBA with nine years of experience who did not know anything about user defined database roles or even that...

The simple answer is no.

Always use Surrogate keys for the primary key. Add unique constraints on all natural keys (alternate keys).

Any other approach will eventually get you in trouble.

Are the databases published for replication?

What is the result of this:

DBCC OPENTRAN

nirmal jain (10/13/2010)

---

I am a SQL Server DBA for last 11 years. At my current job, I am managing nearly 250 SQL Servers with versions 2000, 2005 and 2008...

You are making it too complex.

select

*,

FirstDayRollingYear=

dateadd(yy,datediff(yy,0,dateadd(mm,-1,a.DT)),0),

LastDayRollingYear=

dateadd(yy,datediff(yy,-1,dateadd(mm,-1,a.DT)),-1)

from

( -- Test Data

select DT = convert(datetime,'2010-01-01')union all

select DT...

DucatiRider (10/13/2010)

---

Thanks for the reply! How can I get a 1/1 date for the current year that will return 1/1 of the prior year when I use it in...

select

LastDayCurrentMonth= dateadd(mm,datediff(mm,-1,getdate()),-1),

LastDayPriorMonth= dateadd(mm,datediff(mm,-1,getdate())-1,-1)

Results:

LastDayCurrentMonth LastDayPriorMonth

----------------------- -----------------------

2010-10-31 00:00:00.000 2010-09-30 00:00:00.000

(1 row(s) affected)

GilaMonster (10/12/2010)

---

Yeah, I...

GilaMonster (10/12/2010)

---

There's a running joke...

Get rid of the "th" after "24".

select convert(datetime2,'May 24 2010') AS MyDate

Results:

MyDate ...

Since the source of data is a TXT file created with BCP, why don't you just order the TXT file in the order you want by using a query with...

Full text search would probably be the best option.