Well done on posting your script to share your knowledge.

I would, however, like to suggest that 1) low row or character counts should never be used as a justification for...

@harsha-2 (and ayoe else interested),

Thanks for taking the time to post a script but you have to be very careful with recursive CTEs. Please read the following article for...

Thank you for the feedback. 🙂

Pravasis (4/14/2013)

---

Mansfield (4/11/2013)

---

1. Joining integer columns (provided that they are correctly indexed) is faster than joining other data types because it is relatively straightforward (see below)

2. It depends....

You need to apply a good splitter to each CSV. Like this.

SELECT s.Owner_Name,

SeatNo = split.Item

FROM dbo.Source s

CROSS APPLY...

The simple explanation is "converting rows to colums". For how to do that in T-SQL, please see the following article.

http://www.sqlservercentral.com/articles/T-SQL/63681/

In MS Excel and other "front end" reporting, pivoting is...

j.miner (4/8/2013)

---

select @var_months3 =

(

case

when @var_cnt = 1 then 'jan'

when @var_cnt = 2 then 'feb'

when @var_cnt = 3 then 'mar'

when @var_cnt = 4 then 'apr'

when @var_cnt = 5 then 'may'

when @var_cnt...

vsts.dev (4/5/2013)

---

But I need to pass multiple values to the parameter

like

exec 4,5,6

and desired result should be

TranID | MonthValue

...

Erin Ramsay (4/9/2013)

---

Hey Jeff?

I read your article and I know it's been a loooooooooooooooong time but you know you could replace this:

--=====...

mic.con87 (4/12/2013)

---

Hi,

I have 3 categories ie Voice, Data, SMS.

I have a list of case statements that I currently run based on these categories.

SUM(CASE WHEN categ = 'Voice'

AND rev <> 'ICT'

THEN...

winmansoft (4/13/2013)

---

In our production sql server we have so many important databases. I have created two login 'admin'(has all permission) and 'read'(has only public and datareader permission) . I...

sweeneyliam71 (4/13/2013)

---

I have tried

select id, SubjectText from dbo.email where contains

([ContentText],'"( (execute near class, near program ,NEAR code,near SQL ))"',2,true);

go

and

select id, SubjectText from dbo.email where...

To see how the query that JLS wrote works, please see the following article.

http://www.sqlservercentral.com/Forums/Topic935472-392-1.aspx

To learn how to do the same in a dynamic condition where the column...

Change the "AND" to an "OR".

eseosaoregie (4/13/2013)

---

Hi Jeff, thanks for your reply. I will give this a go when i am back at the office. Just one question for future reference. What is an EAV...