How about sequencing the new column [GroupBy] using ROW_NUMBER()?

You can probably figure it out from this:

SELECT *, [GroupBy] = TestDate - rn

FROM (

SELECT *, [rn] = ROW_NUMBER() OVER(PARTITION BY TestId ORDER BY TestDate)

FROM tblDatesSequenceTest

) d

appdev13 (3/18/2015)

---

I am having a table with over 120 million rows. I am executing a count query and it is taking about 4 mins to execute. Every 1 second 100...

rexyrexin (3/18/2015)

---

I got the answer:

select * from mytable

where class='something'

AND ISNULL(xyz,0) = CASE WHEN @abc = 1 THEN 1 ELSE ISNULL(xyz,0) END

Here @abc is the stored procedure parameter .

Thanks all for...

You're holding it upside down:-P

chris.rogers00 (3/16/2015)

---

Why does this code (below) cause a change in the transaction state?

DECLARE @date DATE,

@string VARCHAR(5)= 'test'

BEGIN TRAN

PRINT XACT_STATE()

BEGIN TRY

-- see if the data I've been given can be cast...

Then try SUBSTRING(string, startpos, 8000) or calculate the correct length for the third parameter.

sqlquery29 (3/17/2015)

---

Thanks andy...

We have like after 40 characters the unit of measure is place in the description field. We have more than one space between the description and unit of...

WolfgangE (3/16/2015)

---

hi,

thank you for the answer.

I know I could optimize the index, but that's not the point. I'd like to understand why optimizer is estimating the way it does...

Try these indexes:

CREATE INDEX ix_MasterId_Etc ON DetailTable (MasterId, CreateDate) INCLUDE (DetailId)

CREATE INDEX ix_MasterId_Etc ON MasterTable (Name, MasterId)

These are a first guess based on the join columns, filters and output...

APPLY has been a part of TSQL since 2005. Read more here:

http://www.sqlservercentral.com/articles/APPLY/69953/%5B/url%5D

-- Check

WITH SequencedData AS (

SELECT *, rn = ROW_NUMBER() OVER(PARTITION BY emp ORDER BY rdate DESC)

FROM #sample

)

SELECT *

FROM SequencedData s

CROSS APPLY (SELECT TOP 1 * FROM #sample si...

measterbro (3/13/2015)

---

i split my query into ~4K pieces and assigned each piece to a variable. Then i assigned them to one, and executed it.

SET @DynamicPivotQuery = @part1 + @part2 +...

measterbro (3/12/2015)

---

Unfortunately I am not able to post data or DDL since it is proprietary. I just thought there might be a known problem with dynamic SQL and appending variables,...

measterbro (3/13/2015)

---

Your GamesWon definition gives these errors:

Msg 207, Level 16, State 1, Line 15

Invalid column name 'LeagueName'.

Msg 207, Level 16, State 1, Line 16

Invalid column name 'ShortName'.

Msg 207, Level 16,...