cant i use my method of querying? after removing the time value  the date field will be left only with datevalue so this query should work?

Sorry for the confusion. Sure,...

Jumped the gun

Interesting phrase with a suprising translation. Did know this one, but surely will keep it in mind when I jump the gun next time. Thanks!

okay,okay... I don't want to be branded as troublemaker.

But what when you have data like A2 or the like? This should also be taken into account.

Same execution plan, Dave! The optimizer is bright enough to figure this out. Damn, can't remember where I saw a neat, handy solution for this (apart from doing this at...

See, if this helps:

http://www.sommarskog.se/arrays-in-sql.html

Now, if I understand you right, why do you CONVERT at all? Can't you simply change the input parameter datatypes to DATETIME?

If the table has a DATETIME column, and you...

See, if this helps:

set nocount on

create table #rt

(

 c1 int identity

 , c2 int

)

insert into #rt values (1)

insert into #rt values (2)

insert into #rt values (3)

insert into #rt values (4)

insert into #rt...

SELECT

     *

FROM

     sysindexes i

WHERE

     i.indid BETWEEN 1 AND 254 

/* Each table can have up to this number of indexes, including the clustered index (indid=1 and some special...

Oops, sorry, I'm that much used to something like this

 .Parameters.Append .CreateParameter("@sql", adVarChar, adParamInput, 4000)

that I didn't see that you used the numeric equivalent. Sorry, if that has lead to confusion.

Pretty much self-describing

cmd.Parameters.Append (cmd.CreateParameter ("@monthselected", 17, 1, 0, monthSelected )) is missing OUTPUT.

Good luck on your search!

Do a search on the Google groups on that. I remember seeing that question there recently, but can't find the link right now. IIRC, someone from MS responded there.

Sorry, I really, really don't want to sound offending, but don't you think you can find this out yourself? Is this for some kind of exam or homework?