There are several ways that you can accomplish this. Probably the most straightforward is the following.

SELECT CAST(CAST(GETDATE() AS DATE) AS SMALLDATETIME)

Drew

It's possible to do this with SSIS, but SSIS is complicated enough that I would not recommend trying this as your first SSIS project.

Drew

All results of a CASE expression must be of compatible data types and the data type with the highest precedence determines the final data type. You return a mix...

John Mitchell-245523 (8/26/2016)

---

There are pros and cons. Your query will return (possibly) unexpected results if there are gaps in the data or two dates in the same week. ...

Now try it with this data

INSERT INTO #tbl_data (

Time_Started

)

VALUES('2017-01-06 09:08:47.763'),

('2016-12-30 09:08:47.763'),

('2016-12-23 09:08:47.763'),

('2016-12-16 09:08:47.763');

This is why I asked about wrapping and...

If by "slice", you mean filter, windowed functions are calculated after the WHERE clause, so the running total reflects any filters applied in the WHERE clause.

Drew

sharonsql2013 (8/25/2016)

---

I am getting last 4 week numbers in a query - say 31 thru 33.

How can I rename 31 as week 1 , 32 as week2 , 33 as...

I had to stop after number 12. There is no way...

JALLYKAMOZE (8/25/2016)

---

CREATE TABLE DELAYSECONDS(

ProgramID INT, ID INT, ContractHeaderID INT, ContractStartTime TIME, ProgramStartTime TIME ,ContractDetailFirstDay INT ,ProgramFirstDay INT, DelaySeconds INT)

INSERT INTO DELAYSECONDS

VALUES (625, 625, 115278, '18:00:00', '18:00:00', 2, 2, 0),

...

The sequence number IS coming from TableA.

Part of the problem, is that you haven't been able to...

I think what you are looking for is ROW_NUMBER(). Something like the following:

SELECT *, ROW_NUMBER() OVER(ORDER BY <pick some order here>) + ( SELECT MAX(sequence) FROM TableA)

FROM TableB

Drew

I haven't looked at the calculations, but replace your nested cursors with this. And why go to the trouble of specifying a name for the day of the week...

The Dixie Flatline (8/23/2016)

---

Drew, the pattern of this data is what I think of as header/detail data. One very significant "S" row followed by a bunch of "B"...

There are obvious problems with the "expected results" -- such as all of the times being the same and dates in the results that don't exist in the sample data...

Yes, use a different approach. Either shred the XML and make your adjustments on the shredded data or use .modify() to modify your XML.

Since you haven't provided sample data...