Viewing 15 posts - 1 through 15 (of 20 total)
Thank you gentlemen.
May 31, 2018 at 2:01 pm
Do I have this wrong? if a baseDate of 1/1/2006 at 07:00 represents the beginning of Shift A, then the shift date of 12/31/2005 at 06:00 represents shift B....
December 22, 2016 at 1:26 pm
June 12, 2012 at 10:41 am
excellent. thank you. so it appears that I should use type string and validate using regular expression as I just can't get non string data types to allow...
June 12, 2012 at 9:54 am
Thanks everyone for taking the time and offering your expertise. I wasn't sure how much to post in the forum since the stored procedure that this comes from is...
April 27, 2012 at 10:28 am
I now have learned what WITH does and ROW NUMBER. On a quest to figure out OVER and PARTITION.
I am now trying to apply the suggested solution...
January 12, 2011 at 11:25 am
Thanks. It looks like it does exactly what I need. I would like to learn more about how this works. Got any good reference sources to recommend?
January 12, 2011 at 10:22 am
Based on running this query for the last two months worth of data, after applying the proper filtering, it would seem that you have solved the issue for me. ...
November 2, 2010 at 3:48 pm
cool cool cool. upon first run on the test data when filtered for the corerct exit month, it looks like it did it. I'll let you know if...
November 2, 2010 at 2:57 pm
Thank you sir for a working example. This gets me closer.
The requirement is I need to take a look at clients who have exited a particular social...
November 2, 2010 at 11:42 am
Could some one provide me with an example?
November 1, 2010 at 2:37 pm
Thanks for all the input thankfully it is unlikely that I'll need to iterate thousands of records since I will be running this report once a month and only be...
October 27, 2010 at 12:54 pm
Using cross apply and changing the outer join to inner got me very close. The problem is that the results are excluding clientid 1. I believe this is...
October 26, 2010 at 12:31 pm
Thank you very much for the work put into this. It is close to what I need, and I will see if I can work out how to get...
October 26, 2010 at 11:14 am
Thanks for the quick reply. It does indeed cascade. And I would like an example to build upon if possible.
October 25, 2010 at 3:04 pm