I am not sure I understand your question? where does the create date come in and what or how are you looking to compare? there are lots of ways...

If all you are doing is a check to see if the entered date is not greater than today and not more than three years ago then your code seems...

I am not sure this is specific enough to your question but the following would give you the date minus 240 minutes

select dateadd(mi,-240,Getdate())

Here is a link to an article that may help you.

http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/

this is a little better code it uses a CTE instead of the table variable.

create table #temp (CaseID varchar(3),Dt Datetime,StatusCd varchar(6))

insert into #temp (CaseID,Dt,StatusCd) values('ABC','06/02/10','ACTIVE')

insert into #temp (CaseID,Dt,StatusCd) values('DSA','06/04/10','ACTIVE')

insert into...

If all you need is a count then the following should work for you. I am not sure this is necessarily the best possible code but I beleive it...

If you where a box of crayons what color would you be and why?

I love when these types of questions get asked!

Can someone tell me how this tells them...

you disabled the instance of SQL? then how does SQL respond to anything?

To help you get some responces I formated some table code for you. Couple question for you though. What whould the output you are looking for be? also...

I thought I would add something that I used to do when I conducted interveiws. I would ask the candidate to rate themselves on a scale from 1 to...

That is a rather broad question so here are some follow up questions. Is there anything besides SQL running on the server? How do users interface with SQL?...

I am ok with a basic code test in the interview process but I would hope that this does not become an extensive process. I for myself may never...

We have just started using foudation server. This seams to be a very useful tool. this may be more than you need but so far I like the product...

Edited: Sorry I did not see the bottom paragraph. well the query is reformated anyway.lol sorry I did not see your explanation at the bottom.

there seams to be two...

Here is an article with many different solutions for duplicate records. it is hard to say which is the one you are looking for.

http://www.simple-talk.com/sql/t-sql-programming/removing-duplicates-from-a-table-in-sql-server/