Yes but you will have to wait for Italy to be forced to...

Bit of typos there i think and as such a really hard question to answer. The hard part trying to figure out what the author wanted to demonstrate. In this...

Something like

with cte as

(select CustomerId, RechargeDate, Count(*) RechargeNr

from customer_trans

group by CustomerId, RechargeDate)

select c1.CustomerId, c1.RechargeDate, sum(c2.RechargeNr)

from cte c1

join...

bitbucket-25253 (8/23/2011)

---

venoym (8/23/2011)

---

I thought it was a fine question.

I'm surprised by the number of people who are complaining about the existence of a Test2 db or not. I...

So BOL is wrong. From the link

It is strongly recommended that you do not create any stored procedures using sp_ as a prefix. SQL Server always looks for a stored...

Your welcome 😎

/T

Well you cant replace it with just BR you need the whole part "<br>"...

Hakuna Matata :):):) (7/8/2011)

---

I am using the function to send a report using Database Mail as shown below.

Is there any other go wherin I can I can show multiple...

Modding my code so it should do what you now want.

SELECT t.id,

RTRIM(SUBSTRING(t.s, 1, 36)),

...

I must say that i dont see the problem. Since that is the way you will get it out. But as i said. SSMS will NOT display the line breaks...

Or another option

select

Stuff( (select distinct

',' + t.fldName1 + ',' +

...

Hakuna Matata :):):) (7/8/2011)

---

Hi

When I use this in a select statement as shown i get Sql Server

declare @Str1 varchar(32)

declare @Str2 varchar(32)

select @str1='Sql', @Str2='Server'

select @str1 + char(13) + @str2

Am I doing...

Something like

declare @Str1 varchar(32)

declare @Str2 varchar(32)

select @str1='Sql', @Str2='Server'

print @str1 + char(13) + @str2

?

/T

mageshh11 (7/8/2011)

---

Thanks for the quick reply.

But all the variables declared in the SP are varchar(max)

Below is the code like which i m using. This may help you to understand my...

A question which i hope someone might be able to answer about the "Union/Cross tab" solution.

Okay so lets say we have a result looking like 1, "Tennis", Null, "Golf",...