hi,

change the below statement in your script

SUBSTRING(list, indCol.splitter +1, 100)

SUBSTRING(list, indCol.splitter +1, 250) --> increase this, your query will work with out errors

To be on safe you can increaase to...

+1

There is learning in every QOTD. thanks for the question

learnt something new today 🙂

Good QOTD

Revenant (5/6/2014)

---

Documentation implies that this should work, but it does not:

DECLARE @b1 AS BIT = 1,

@b2 AS BIT = 1;

DECLARE...

Jeff Moden (5/5/2014)

---

Even though I strongly [font="Arial Black"]disagree [/font]that BIT is an integer datatype simply because it can't be used in certain bits of math, such as a SUM(), I...

I have also answered 'BIT' 😉

find the updated one

DECLARE @MasterTableName AS VARCHAR(255)

set @MasterTableName='parent_table_name'

;WITH ParentChi AS

(

--initialization

SELECT

OBJECT_NAME (fkey.referenced_object_id) AS ParentTable

...

yuvipoy (4/3/2014)

---

Yes similarly kind fof information i need...

+1

I work...

Try with the below query

Note : please replace job_name and step_name according to your code

select

j.name as 'JobName',

s.step_id as 'Step',

s.step_name as 'StepName',

msdb.dbo.agent_datetime(run_date, run_time) as 'RunDateTime',

...

You can also see the below link

http://www.sqlservercentral.com/Forums/Topic226699-5-1.aspx

thank you megha and Hanshi for your replies

thava (4/25/2014)

---

hi there, it is almost same with Stuart Davies's but the logic is different

my solution is avoid the summation two times the other solution using two times grouping...

David Burrows (4/25/2014)

---

SELECT

'Type'[Type]

,SUM(CASE WHEN code='09' THEN Amt/100 ELSE 0 END) AS [Col1]

,SUM(CASE WHEN code='10' THEN Amt/100 ELSE 0 END) AS [Col2]

,SUM(CASE WHEN code='11' THEN Amt/100 ELSE...