If you want to build a date table, the function on this link will give you what you need.

Date Table Function F_TABLE_DATE

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

You should avoid the other solutions posted on this thread, because they depend on the setting of DATEFIRST or LANGUAGE.

This code shows a simple way to do it.

select

DATE,

Mon = dateadd(dd,(datediff(dd,-53690,a.DATE)/7)*7,-53690)

from

--...

It's not that bad if you do it when they're real young and weigh maybe 100 pounds.

If you wait till they're a year old...

I have a hard time thinking of a terrible IT job compared to horrible non-IT jobs.

I got a temporary job once where we went to a site for some “digging”....

I don’t pay any attention to certifications on resumes.

What I look for on a resume is relevant experience, and the ability to clearly explain exactly what they have been doing....

You have to manually supply the name, instead of letting SQL Server pick one.

You can look up the format of the alter table statement in SQL Server Books Online.

You are converting the dates to string before comparing them, instead of comparing dates. Do it like this:

where EffDt >= '20080601' and EffDt < '20070101'

They do not produce the same results; see below:

create table #t ( Message varchar(20), seq int not null identity(1,1))

insert #t

select null union all

select '' union all

select 'xxx'

select * from #t...

You must really be getting old, because Joey Ramone died April 15, 2001. 🙁

http://en.wikipedia.org/wiki/Joey_Ramone

Open file defragmentation is only supported with Windows Server 2003 or higher. It is not possible with Windows Server 2000 or earlier.

You can use the built-in windows defragmentation utility...

jsheldon (7/2/2008)

---

Neither could I, I know it is within the ALTER TABLE command and that's what I put as my answer

I didn't give very detailed variable specifics when naming...

lherrerag20 (7/2/2008)

---

Why don't you create a SP to autopurge the log, i have a function, and belibeme it's so good not to worring abut the logs after made that.

I put...

You can use the script on this link to get information on all databases on a server at the same time.

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

If you have the time, and think you might want the job, there is no harm in taking the test.

The worst that can happened is that you don’t get a...

I use different SQL Server service accounts and passwords for each SQL Server instance. We have about 200 SQL Server instances; so it is out of the question to...