Viewing 15 posts - 1 through 15 (of 433 total)
Here is what I am looking at which provides the proper results but still seems too RBAR.
declare @today datetime = '9/23/2016'
declare @rc int
declare @complete table (suspid int);
September 25, 2016 at 6:59 pm
Each entity has successive periods. They can continue forever.
Your CTE is adding the total suspension duration in the first period. The solution must apply the suspension to...
September 25, 2016 at 8:09 am
The incentive periods are 3 calendar months if there are no suspensions not including the end date in your example.
If an agreement starts on 1/1/2016 then the baseline incentive periods...
September 25, 2016 at 5:20 am
You are setting the method to post but appears you should be doing a get. POST is should only used when you are passing a payload back to the...
September 24, 2016 at 5:32 pm
I think I originally got this from Steve Jones or at least one of his posts. Made a couple of tweaks to handle Roman Numerals because we mostly use...
October 18, 2010 at 7:24 am
If your supplier data is unique the you don't need distinct when looking for records that don't match since there should only be one of each to begin with. ...
July 7, 2010 at 2:59 pm
Thanks Greg, There is actually a whole other part of the query that deals with the randomization of the records that I left out to simplify the issue to the...
July 7, 2010 at 2:04 pm
Sorry Lutz, I just didn't read it that closely.
July 6, 2010 at 2:02 pm
This would be easier to help you with if you provided some sample data and sample results. I still believe you can do this with a set based solution.
July 6, 2010 at 1:46 pm
so is the inner query really running one time for each typeid?
July 6, 2010 at 1:36 pm
That works great but I don't get why. I'd appreciate it if you could give me the explaination as well.
July 6, 2010 at 12:14 pm
If I get waht you are looking for 7 new records from each previous record, this should work in one step on the server.
insert into newtable(field1,field2,field3,other fields)
select field1,'Monday' DOW, Field2...
July 6, 2010 at 11:48 am
I also use 8765 knowing only that it fixes the issue of a field returning the wrong data length in ODBC. I would love to know if it...
June 3, 2010 at 7:19 am
I've been doing this with DTS since SQL7. One catch I don't see mentioned is that you have to log in manually the first time to cache the key....
May 11, 2010 at 7:12 am
I think, using Jeff's hint for the select into (I still don't get the (mod 5) + 1) and Lynn's code, I simplified it a little
select identity(int,1,1) did,dlc into...
December 22, 2009 at 9:44 am