Welsh Corgi (6/29/2012)

---

I do not intend to use a WHERE Clause is ths scenario.

After I got the record COUNT correct I was going to incorporate an INSERT INTO with CASE...

What is the maximum number of discrete values to be found in the comma-delimited string?

SELECT Data

INTO #PIDs

FROM dbo.Split('101,103',',')

CREATE CLUSTERED INDEX [xyz] ON #PIDs (Data)

SELECT *

FROM dbo.Product_Test p

INNER JOIN #PIDs d ON d.Data = p.PID

Welsh Corgi (6/29/2012)

---

I'm trying to get all the records from the History Table (39,026) but after I join I get only 26,086.

What is wrong with my statement and how can...

SQL Server will ignore both the TOP(100 percent) and the ORDER BY. You should reconsider what you are trying to do here.

I'd be interested to...

This shouldn't be too difficult.

What does @PivotColumnHeaders look like?

Can you provide DDL for the two tables, with some sample data?

SELECT Username,

DateFrom = MIN([Date]),

DateTo = MAX([Date]),

CodeFrom = MIN(Code),

CodeTo = MAX(Code)

FROM (

SELECT Username, [Date], Code,

rn = ROW_NUMBER() OVER(ORDER BY Username, Code),

dr = DENSE_RANK() OVER(ORDER BY Code)

FROM @originalTable

)...

dwain.c (6/28/2012)

---

Jeff Moden (6/28/2012)

---

Not just the CROSS APPLYs but the fact that the 2nd CA refers to the 1st. Until ChrisM showed me, I haven't even tried that wonderful...

It's awful isn't it! I don't think it can be improved either.

patrickmcginnis59 (6/27/2012)

---

ChrisM@Work (6/27/2012)

---

@CLASSIFICACAO is declared as an int, you have to cast it as a string type to concatenate it into the string:

SET @STRSQL = 'INSERT INTO ' + @DB...

@CLASSIFICACAO is declared as an int, you have to cast it as a string type to concatenate it into the string:

SET @STRSQL = 'INSERT INTO ' + @DB + '.DBO.SINCRONISMO...

You should be able to figure it out from this:

SELECT x.months, [YYYYMM] = CAST(CONVERT(CHAR(6),Months,112) AS INT)

FROM (VALUES (0),(1),(2),(3),(4),(5),(6)) r (n)

CROSS APPLY (SELECT Months = DATEADD(mm,-n,GETDATE())) x

ramadesai108 (6/26/2012)

---

Also, I forgot to mention that it is a dynamic query and here is the SP:

Create PROCEDURE [dbo].[MySP]

(

@OrgId int,

@DivId int = null,

@EmpId nVarChar(MAX) = NULL,

@year int

)

AS

DECLARE @sql nVARCHAR(MAX)

DECLARE...

@River1, here are two useful hints for you:

1. Don't encapsulate a batch of statements into a stored procedure until you've finished debugging them - it's much easier to debug a...