Sean Lange (5/29/2015)

---

sarath.tata (5/29/2015)

---

Sean Lange (5/29/2015)

---

Your question is not at all clear. What would be helpful is if you could post ddl and sample data in addition to the desired...

Sean Lange (5/29/2015)

---

Your question is not at all clear. What would be helpful is if you could post ddl and sample data in addition to the desired output. I think...

Just in case somebody wants

DECLARE @StartDate DATE

DECLARE @EndDate DATE

DECLARE @RotationDays INT

SET @StartDate = '01/01/2015'

SET @EndDate = '12/31/2015'

SET @RotationDays = 4

;WITH result AS

(

SELECT DATEADD(DAY, (ROW_NUMBER() OVER...

Eric M Russell (5/29/2015)

---

The following will easily give you what you want, without resorting to a loop. It basically just applies row_number() across a resultset to get a sequential set...

I have found a solution. Not so sure, if it is the best solution!!

DECLARE @StartDate DATE = '01/01/2015'

, @EndDate DATE = '01/08/2015'

SET @StartDate = DATEADD(DAY, -7, @StartDate)

;WITH...

Is this solution efficient?

DECLARE @NextNumber BIGINT

BEGIN TRAN

SELECT @NextNumber = NextNumber FROM tblOnboardingSequence WITH (HOLDLOCK, ROWLOCK) WHERE Name = 'TPO'

UPDATE tblOnboardingSequence SET NextNumber = @NextNumber + 1 WHERE Name = 'TPO'

COMMIT...

I don't understand the reason but when I removed alias in column name it worked!!

SELECT DutyRosterPeriodID, StartDate, EndDate, CASE WHEN HolidayDate IS NULL THEN 0 ELSE 1 END...

I can't use global temp variables as it differs per request.

if my query is in @sql, so far I could find the way to pre-create temp...

I could n't give complete executable query as it is part of a dynamic query which requires plenty of tables.

This is my pivot. Do you think I missed some...

It is strange!! I had this query as part of another Pivot query. The error might be because of that. I need to look into this now. ...

Nice work

Steven Willis (12/7/2010)

---

Someone recently posted a function like the one below that I have modified to validate US/Canadian format phone numbers. Sorry that I can't remember the OP to...

I think I may better use Left in stead of Replace

SELECT

CASE WHEN CHARINDEX(' ', Supervisor, CHARINDEX(' ', Supervisor, 0) + 1) > 0 THEN

LEFT(Supervisor, CHARINDEX(' ', Supervisor, CHARINDEX(' ',...

It seems the weekend break worked for me to think fresh!!

I glanced through the query and found that I'm using joins on the columns that are not indexed and as...

Thanks for your ideas. I'll look into them. By the way, do you mean this below on the usage of alias in UPDATE?

UPDATE asft SET LastRemoved =...

You are absolutely correct!! I realized later that my posted query has no impact but the one in the error log has created deadlock!! Any guesses how to tune that?

It...