Search results for query: *

Since you are passing in parameters then maybe it is a stored procedure that you are running? If so you could construct your sql statement in code based on the inputs declare @sqlString as varchar(255) ... select @sqlString = @sqlString + @sqlwhere ... EXEC master.dbo.sp_SQLEXEC @sqlString

This looks to me like a problem with the date format e.g. dd/mm/yy or mm/dd/yy - Do you get the same problem if you pass through dates like '04/04/2002' rather than '04/20/2002'? If this is the problem then you could try either passing the string in the SQL server default format (this depends...

When you create a database you will have specified devices, and whenever you create a table you specify which device to store it on, or it goes to the default device. There isn't necessarily one device per database. You should be able to view the devices in the console, or you can find the .dat...

I got a bit confused with what your problem was. However, I know that I have had HUGE problems with date formats, with different computers getting different results when using the same asp page and the same database..... I now try to always format the month in letters. Here is a bit in asp to...

what about select t1.c, t1.num, t2.num, t3.num from (select contributor as c, count(*) as num from table where medal = 1 group by contributor ) as t1, (select contributor as c, count(*) as num from table where medal = 2 group by contributor ) as t2, (select contributor as...

Try using the Ascii 13 for a new line eg. select product + CHAR(13) + product_grade

I don't know if this is the problem, but in my version of SQL server I don't seem to have a TOP function. To accomplish the same thing though: SET ROWCOUNT 5 SELECT sample_number FROM sample Order by sample_number DESC SET ROWCOUNT 0