yuvipoy (11/5/2012)

---

No, i am looking alternate method for pivot.

i have used another way like

DECLARE @input varchar(4000);

DECLARE @sql NVARCHAR(MAX)

select @input='101011123'

SELECT @sql = ISNULL(@SQL+N','+CHAR(10),'') +

...

DECLARE

@MyInput VARCHAR(8000),

@MyOutput VARCHAR(8000)

SELECT

@MyInput = '101011123',

@MyOutput = ''

;WITH MyTable (startid, Length) AS (

SELECT 1,1 UNION ALL

SELECT 2,1 UNION ALL

SELECT 3,1 UNION ALL

SELECT 4,2 UNION ALL

SELECT 6,3

)...

yuvipoy (11/4/2012)

---

Say i'm having a string like this '101011123'

i need to split the sting based on my statid & endid

startid, endid

1,1

2,1

3,1

4,2

6,3

which needs to split something like

1,1---->1 starting...

Work on the function in isolation from the rest of the code. It's a rows to columns transformation using a well-known cheat;

SELECT @r = ISNULL(@r+'/', '')

+ DH.DESCRIPTION + '...

Look up RTRIM() in Books Online.

Check the datatype of the column 'name' - is it CHAR()? Sounds like it should be VARCHAR().

Materalise the ORDER BY expression in the output to see what's happening:

select top 300 -- widen the range to observe the effect of the ORDER BY

OrderBy = str(isnull(@SortFieldIndex,2)) + @OrderBy,...

yuvipoy (11/1/2012)

---

can we add

startid, endid SplitLayout

startid, endid

1,1

2,1

3,1

4,2

6,3

9,1

10,5

15,4

19,3

22,4

Startid = will start from 1 and will add endpoint for second row 1+1 =2 will be starting point for second row...

Simplify your model. Pick...

Why are you using dynamic sql for...

sqldba_newbie (10/31/2012)

---

CREATE TABLE #Sid

...

There’s your problem. You’re only updating a maximum of a few tens of thousands of rows in the target table, but the source – now rejigged as a SELECT for...

Where? Without knowing how #sid is populated, it's impossible to do what you are asking.

How many rows are returned by the SELECT version of the first update in your script?

SELECT PatientKey = P.PatientKey

, AgeKey = PM.AgeKey

, GenderKey = P.GenderKey

, GenderCode =...

-- formatted original

select distinct

t1.ServerName,

t1.[Application ID],

t1.[Application Name],

t2.VP1,

T2.VP2,

T2.SVP,

T2.[DC2015 Move Group],

T1.[System Type],

T3.Line,

-- defines 1 column

AppServerSource = (

Select -- returns 3 columns

IsNull(t1.ServerName,t2.ServerName) as ServerName,

IsNull(t1.[Application...

chandan.kumar (10/30/2012)

---

Hi Don,

Can you please check below query -

SELECT c.*, h.*

FROM #CONTACT c

INNER JOIN (

SELECT Accountno, ROW_NUMBER() OVER(PARTITION BY accountno ORDER BY lastdate) Rownum ,RECID FROM #History

GROUP BY...