You could use dynamic SQL for each DELETE, thus having a separate sql command executed for each group.

This query should help

DECLARE @sql VARCHAR(MAX);

SELECT @sql = 'WITH cteMinMax AS (' + CHAR(10)

+ ' SELECT' +...

pinky_sam05 (12/11/2016)

---

I am using sql server 2012.I have been assigned a task where one of my column(JsonText) of table(Sample) contain json data.I want to parse that data and insert into...

ma701ss (12/11/2016)

---

Hi, thanks for the replies.

This code returns the user id but what I want it to return is either 1, -1 or -2. My vb code then uses a...

dudekula.kareemulla (12/9/2016)

---

Hi

I have a query like below. table contains 70 million records

select MIN(createtime) _time_ from tablename

where status <> 20 and type_id = 44

and createtime >...

If you use invoice_lines_I03 to replace...

What CLUSTERED index does the table have?

User-defined functions cannot make use of dynamic SQL or temp table

Source: https://msdn.microsoft.com/en-us/library/ms191320.aspx

If you need to use Dynamic SQL, then change your function to a Stored Procedure.

replace FSI.StepCompletion

with CONVERT(VARCHAR(30), FSI.StepCompletion)

Is this for a Gregorian calendar year, or a fiscal year?

OK. First things first.

Your #temp needs to change the datatype of UpdateDate

CREATE TABLE #temp (

[Type] VARCHAR(1)

, TableName VARCHAR(20)

, ClientID VARCHAR(10)

...

I cannot imagine any method that will not be a massive hit on your server.

Perhaps if you explained why you need to create such a massive amount data, some of...

This piece of code will not work for @NumberOfRows > 31.

urbanromio2 (11/27/2016)

---

Declare @NumberOfRows int;

Declare @Numbers Table(Number int);

;With cte As

(Select 1 As Number

Union All

Select Number + 1

From cte

Where Number < Power(2,...

You want to look into the PIVOT relational operator

https://msdn.microsoft.com/en-us/library/ms177410.aspx

With a few nested queries, you could also sue the following code to generate the JSON

SELECT '['

+ STUFF((

...