Is count of followupdate fixed ?

This may help you...

select

distinct t.patientid, stuff(

(

select distinct ' '+ convert(varchar(12),followupdate, 103)

from followup as t1

where t1.patientid = t.patientid

for xml path('')

),1,1,' ') from followup as t;

You should ask such questions in the forum of site

http://www.sqlservercentral.com/Forums/Forum433-1.aspx

Bhuvnesh (3/25/2010)

---

try this select TransactionID,

sum(TOT) as TOT,

sum(UniqueEnvs) as UniqueEnvs,

sum(GBX) as GBX,

sum(IEX) as IEX,

sum(UNK) as UNX,

DateTimeReceived

...

Kingston Dhasian (3/25/2010)

---

SELECTpkTransactionID, [TOT],

ISNULL( [TOT], 0 ) + ISNULL( [GBX], 0 ) + ISNULL( [IEX], 0 ) + ISNULL( [UNK], 0 ) UniqueEnvS,

[GBX], [IEX], [UNK], DateTimeReceived FROM(

SELECTpkTransactionID, LEFT( ComponentText, 3...

BrainDonor (3/25/2010)

---

Yet another way:

--CREATE TABLE tblCompany(

--CompanyIDint,

--CompanyNamevarchar(max),

--Activevarchar(5),

--LastModifieddateTime

--)

--INSERT INTO tblCompany(CompanyID, CompanyName, Active, LastModified)

--SELECT 1, 'A Company', 'Yes', '01 MAR 2010'

--UNION

--SELECT 2, 'Another Company', 'Yes', '01 MAR 2010'

--UNION

--SELECT 3, 'Yet Another Company', 'No',...

dec_obrien (3/25/2010)

---

Hi,

I'm trying to build an sp that will return a list of companies where the company first letter is specified. I also want to cater...

As per my knowledge by T-SQL Table script can not be generated :unsure:

You can use the following to avoid cursor

DECLARE @string VARCHAR(MAX)

SET @string = ''

SELECT @string = @string + 'EXEC ( ''sp_helptext ' + name + ' '')' from sys.sysobjects where xtype...

Excellent BrainDonor, really appreciable :Wow:

Bhuvnesh (3/10/2010)

---

sinamora (3/9/2010)

---

Day1 Day2 Day3 Day4 Day5

12 3 ...

below will give you those column names and values which have not any null value

;with cte as

(

SELECT ColumnNames, Value, COUNT(ColumnNames) AS cnt

FROM

(

SELECT day1, day2, day3, day4, day5 FROM days

)...

Please post table structure for dates

Ramesh sir,

I was also working with in infoton vile parle.

I also left infoton 1 month before.

I listent a lot about you...

and most of the procedures of paysmart was written by...

This may give you required output....

DECLARE @tbl AS TABLE ( [pkId] int, [Col1] int, [Col2] int, [Col3] int, [Col4] int )

DECLARE @tbl1 AS TABLE ( [pkId] int, [Col1] int, [Col2]...