Viewing 15 posts - 61 through 75 (of 79 total)
Is count of followupdate fixed ?
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 26, 2010 at 4:57 am
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;
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 26, 2010 at 4:12 am
You should ask such questions in the forum of site
http://www.sqlservercentral.com/Forums/Forum433-1.aspx
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 26, 2010 at 12:47 am
Bhuvnesh (3/25/2010)
sum(TOT) as TOT,
sum(UniqueEnvs) as UniqueEnvs,
sum(GBX) as GBX,
sum(IEX) as IEX,
sum(UNK) as UNX,
DateTimeReceived
...
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 25, 2010 at 7:07 am
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...
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 25, 2010 at 5:45 am
BrainDonor (3/25/2010)
--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',...
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 25, 2010 at 4:14 am
dec_obrien (3/25/2010)
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...
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 25, 2010 at 3:58 am
parthi-1705 (3/24/2010)
HiBut What about scripting Tables i need to script tables how to do it.
Thanks
Parthi
As per my knowledge by T-SQL Table script can not be generated :unsure:
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 24, 2010 at 5:59 am
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...
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 24, 2010 at 5:02 am
Excellent BrainDonor, really appreciable :Wow:
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 19, 2010 at 5:18 am
Bhuvnesh (3/10/2010)
sinamora (3/9/2010)
12 3 ...
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 10, 2010 at 3:03 am
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
)...
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
March 10, 2010 at 2:41 am
Please post table structure for dates
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
February 26, 2010 at 2:35 am
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...
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
February 25, 2010 at 4:52 am
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]...
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
February 25, 2010 at 4:48 am
Viewing 15 posts - 61 through 75 (of 79 total)