You could consider doing the DELETE/UPDATE in one fell swoop using a MERGE.

WITH Template AS

(

SELECT TID, LineID, ProductID

,rn=ROW_NUMBER()...

Here's another way.

SELECT [Count]=COUNT(*), [State]

,CreatedOn=STUFF(y, 5, 1, 'Q' + q)

FROM dbo.Ticket a

CROSS APPLY

(

SELECT LEFT(DATEPART(year, CreatedOn), 4) + ' '

...

You should probably try to answer Jeff's questions. It is very likely he's got something superior...

A man of mystery then. Not so easy to climb into your mind as you may think.

Jeff Moden (2/10/2014)

---

Regardless of the number of rows in the table, this can be done incredibly quickly IF you're only looking for one set that adds up to the desired...

BTW. If you're going to use this solution, you're going to need to understand the dynamic SQL anyway. So I suggest that you do so by attempting to...

To clarify a bit on my "black box" dynamic SQL solution, it builds a query that looks like this (with not the same indentation of course):

SELECT d.A, d.D, d.E

FROM #Table2...

This way should be a little faster than what I was originally thinking about.

CREATE TABLE #Table1

(

A INT PRIMARY KEY

,B ...

How big is Table B?

I know of one way for sure but if you've got lot's of rows in Table B it will be quite slow.

You can use FIRST_VALUE for the first case or MIN for either case.

WITH PreAggregate AS

(

SELECT CustomerID, OrderDate=MIN(OrderDate)

--FROM #SalesOrderHeader

FROM...

Sorry but I don't have/use Adventure Works.

declare @TableName varchar(50)

set @TableName = 'Hosea_tblDATA_NOTES'

DECLARE @SQL NVARCHAR(MAX) = N'select * from ' + @TableName;

EXEC sp_executeSQL @SQL;

You cannot SELECT from a local string variable as you're trying to do without...

With DDL for TABLE ApplicationConfiguration, specifically data types for InstanceId and SiteiD, someone might be able to propose a hypothesis.

So...

It seems that the harsh critic has been universally condemned for his harsh remarks. You know what they say about movie critics, if you can't act become a critic!...