Also, for each of the Columns below a variable is used to filter data. Please provide more info regarding these.

LastModified:

@DateFrom

@DateTo

ImportDate:

@ImpDateFrom

@ImpDateTo

ImportId:

@ImportID

If all you are looking for is 'Mark' then the way you are doing it is the correct way.

First, there is a much better split function that we can use. Will get to that later if someone doesn't beat me to it.

Second, I am assuming the the...

.Netter (5/1/2012)

---

Iv seen this done multiple ways but i cant remember them sadly,

Im use to doing

Select Firstname, Surname, Age, HairColour, EyeColour

From Persons

where Firstname = 'Mark'

Can someone show me...

Unfortunately, we can't see you error logs. Can you post a part of the deadlock errors you see in the logs?

Also, what counts are you trying to get. You provided the query you built the cursor on but you didn't show us what you were going to do with...

Would you please post the code for these two functions:

dbo.fn_IsAppType

dbo.fn_Split

Thinking this is what you are trying to get so far?

DECLARE @StartDate as Date;

SELECT @StartDate = CAST(DATEADD(yy,DATEDIFF(yy,0,MIN(LastModified)),0) AS DATE) FROM #TempTable;

WITH CTE(n) AS(SELECT 1 UNION ALL SELECT 1), -- ...

And at this point, what are we doing? Just putting a date into your table? What about the rest of the data? Looks to me like there...

Minor thing first, then I'll look at the rest.

Change this:

Declare @StartDate as Date,

@StartYear As Int

SELECT @StartDate = MIN(LastModified) FROM #TempTable

SET @StartYear...

First, how quickly does the following run:

SELECT

deviceid,

archived,

AVG(CASE WHEN recorddate > DATEADD(day, -7, getDate()) THEN d2.estgasvolmcf ELSE NULL END)...

capn.hector (5/1/2012)

---

Lynn Pettis (5/1/2012)

---

+1. Yes, it is possible.

If you would take the time to read the first article I reference below in my signature block and follow the instructions...

+1. Yes, it is possible.

If you would take the time to read the first article I reference below in my signature block and follow the instructions regarding what and...

Try the following as it looks like it does like you concatenating the string while assigning to a parameter:

use msdb

go

DECLARE @OutputFileName VARCHAR(128);

SET @OutputFileName = 'E:\SQL Server Backup\' + CAST(@@SERVICENAME...

The power users I was taking about were using Access for analytics and reporting. They were few and I worked with them at times to ease the burden on...