Viewing 15 posts - 46 through 60 (of 63 total)
Thank you Sean!
I have tried something like this:
select program, pstatus, form from
(select * ,
ROW_NUMBER() over (partition by program order by len(form)) as RowNum
from #pt
group by program, pstatus, form) x...
February 2, 2012 at 2:07 pm
Thank you all for your comments, All very helpful articles and book for a newbie.
December 31, 2011 at 6:01 am
This is not an exercise Celko, I am a SQL newbie. Thank you for the comment and suggesting the book.
December 31, 2011 at 5:56 am
Thanks eccentricDBA,
Lutz solution explains what my issue was.
eccentricDBA (7/8/2011)
ie
PRINT...
July 8, 2011 at 4:37 pm
Thanks Lutz, That worked.
LutzM (7/8/2011)
something likewhere abc in (5, 6)
OR (abc in (1, 2, 3, 4) AND cde in (123, 452, 78, 124, 458))
July 8, 2011 at 4:35 pm
Thanks Gsquared and Jason.
That fixed the issue.
June 27, 2011 at 1:12 pm
Thanks for the reply Paul.
Any specific reason, is it because of the difference in their architecture?
Thanks.
June 24, 2011 at 10:28 pm
Viewing 15 posts - 46 through 60 (of 63 total)