Chris Morris (1/7/2009)

Also, the above query doesn't get me the desired results. It is getting me an activity for all the columns if there's a corresponding row for any of...

try using sub-query + group by (BranchName,WeekEndingDate) should give you the results you wanted.

post back if you encounter any problems.

cheers 😉

jon

i assume you need help on writting select queries, read following BOL on table joins.

http://msdn.microsoft.com/en-us/library/ms191472(SQL.90).aspx

cheers,

jon

Thanks for posting your solution, nv know when your post would be helpfull.

personally, i think you can skip the casting

if (empty(sql:column("PhySuffix")))

the...

yup agree i don't see a need too either.. anyway i'm not a guru on xQuery but you can use modify's delete method to remove those empty elements but it...

nice point.. but i'll use output clause only when i know how many values to return. If the number of address is "n" number of records then you'll have to...

if you got a single line solution feel free to post it, i'll like to take a look at it. Here's my suggestion (not tested) using a table var as...

doesn't seem to me that you'll need a UDF seems like a SP with a cursor would solve your problem. If performance is a concern then you should adopt what...

Hi jerrym,

No prob 🙂 if u need e first @dteMaintStartDate to be '2008-09-15' and subsequent 7 row to add another 90 on top of e prev row then maybe u...

jon (8/20/2008)

i get 8 rows inserted into the child table but all 8 rows have the date as 2008-09-15, it should add (90 days x i) to the date for...

i get 8 rows inserted into the child table but all 8 rows have the date as 2008-09-15, it should add (90 days x i) to the date for each...

Hi Andras,

Thanks for raising this issue to MS, and the link 🙂

Cheers,

Jon

Hi Andras,

Thanks for e quick reply =)

Shall check MS site for bug patches then 😉

Cheers,

Jon

hi,

when your following tsql is a CTE ("WITH") try it 🙂 it'll ask u to add one ";"

as for my comments on Begin/End use it wisely previously i edited someonelse...

Thanks mathew, yup you r right.. did some googling and learn that this issue has been around but there does'nt seem to hv any answer to it either..

anyway thanks...