Search results for query: *

Hi All, i understand normal paging using using a stored procedure, but how would i page a resultset that has a row with multiple sub rows (like one-to-many relationship i guess) for example. say i return 5 recs per page: id name subid name 1 a 1 w 2 b 2 x 3 c 3 y 4 c 3 y 5 d 4 z if...

Hi All, I understand that its not possible to store multi-dimensional arrays in the application/session/cookies object. Can someone suggest a similar method/workaround for this problem? cheers mitSiguRi

sorry, dont have my head screwed on right today, thanks for the help

lets say #RebillInfo contains dates and values 5/15/2002 to 5/31/2002: [Date] [No] 5/15/2002 0 5/16/2002 3 -- etc 5/30/2002 5 5/31/2002 2 this subquery adds another 2 columns, with the date a month before and the number of sales SELECT [Date],[No],(dateAdd(m,-1,[Date])) as...

ok, just to make the problem clearer, heres the sql SELECT [Date],[No],(dateAdd(m,-1,[Date])) as lastmonth,sales=(select count(*) from WebmasterSales where subid in (select subid from webmastersubsites wsu inner join webmastersites wsi on wsu.siteid = wsi.siteid where...

ok, so is there any way i can make it return '5/01/2002' cheers alan

Hi All, shouldn't the following sql: select dateAdd(m,-1,'5/31/2002') return '5/01/2002' instead of '4/30/2002 im using sql server 7 cheers alan

Hi All, I need help with this wee problem This works in access 2000 query designer: SELECT weekdayname(Duration.StartDay) as [start],weekdayname(Duration.EndDay) as [end] FROM Duration; but when i use the same sql in asp, it gives me: Microsoft JET Database Engine error '80040e14'...

Excellent dude, it worked, you are an sql god! cheers alan

i want to evaluate both situations at once #TempItems contains siteids both null and not null. with ansi_nulls on it should allow me to get a value for JoinHits using siteid=#TempItems.SiteID (where sometimes siteid is an int or its a null) but it doesnt work and i dont know why

that gives me a count when siteid is null on the sub query, but when it isnt null, it includes both the siteid and null in the count. i dont understand why set ansi_nulls off doesnt make it work this works: set ansi_nulls off select count(*) from referer where refdirection='OUT' and...

Hi, wonder if someone can help me when siteid is null in the subquery, the count returned is 0. is there any way to return a value when the siteid is null. i tried setting ansi_nulls off but it doesnt seem to work in this subquery. heres the sql: set ansi_nulls off insert into...