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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.