Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mitsiguri

    paging one-to-many data?

    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...
  2. mitsiguri

    persistant multi-dimensional arrays

    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
  3. mitsiguri

    DateAdd Bug

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

    DateAdd Bug

    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...
  5. mitsiguri

    DateAdd Bug

    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...
  6. mitsiguri

    DateAdd Bug

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

    DateAdd Bug

    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
  8. mitsiguri

    weekdayname function prob

    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'...
  9. mitsiguri

    subquery null problem

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

    subquery null problem

    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
  11. mitsiguri

    subquery null problem

    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...
  12. mitsiguri

    subquery null problem

    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...

Part and Inventory Search

Back
Top