Thanks, Jeff, for posting your approach.. As i dont have SSMS at home, i will check out your code tomorrow and let you know..

But i got a doubt here.....

Use the statement like this

DECLARE @OUTPUT_COUNT INT

EXEC @OUTPUT_COUNT = sp_GetMessageCount '<Your Table Name>'

SELECT @OUTPUT_COUNT

SSMS = Sql Server Management Studio.. Invoke it, Open the Database Node and follow what Mr.Lowell had put in his post...Hope this helps you..

Tom.Thomson (4/24/2010)

---

ColdCoffee (4/24/2010)

---

Nice thread, imho!!

Me born in , une fois par le territoire français (once a french territory) PONDICHERRY, in INDIA! 😉

And now working in chennai (again in INDIA) for...

Tom.Thomson (4/24/2010)

---

ColdCoffee (4/24/2010)

---

Nice thread, imho!!

Me born in , une fois par le territoire français (once a french territory) PONDICHERRY, in INDIA! 😉

And now working in chennai (again in INDIA) for...

Nice thread, imho!!

Me born in , une fois par le territoire français (once a french territory) PONDICHERRY, in INDIA! 😉

And now working in chennai (again in INDIA) for one among...

I guess...

I have 2 solutions in mind.

Solution 1:

1. Ask the csv team to tel give us if the extra columns will be added in today's file.

2. Create many format (*.fmt) files...

Jeff,...

Harsha, there are lot of ways (fast ways included) for performing group concatenation in MS SQL... if u could please post us DDLs for table structures (CREATE TABLE scripts), sample...

At your will, brother!

1. The CTE will collect...

Check out the last post of mine, you will get only the last inserted row for a date, the date,...

Hmm, that would involve a minor tweak in the CTE , andrew... here is the tweaked code..

;WITH CTE(Birthdate,ROWID, DATE_COUNT)

AS

(

SELECT Birthdate, MAX(ROWID) , COUNT(Birthdate) FROM [dbo].[Birthdate] GROUP BY Birthdate

)

SELECT

...

This might be helpful for some who accidentally tumbles upon this thread 😀

IF OBJECT_ID('TEMPDB..#CONCAT_COLUMN_VALUES') IS NOT NULL

DROP TABLE #CONCAT_COLUMN_VALUES

CREATE TABLE #CONCAT_COLUMN_VALUES

(

GROUP_ID INT,

COL_VAL VARCHAR(5)

)

INSERT INTO #CONCAT_COLUMN_VALUES

SELECT...

Andrew, how about this following piece of code??

;WITH CTE(Birthdate, DATE_COUNT)

AS

(

SELECT Birthdate, COUNT(Birthdate) FROM [dbo].[Birthdate] GROUP BY Birthdate

)

SELECT

BD.ROWID,BD.Birthdate, BD.FIRSTNAME, CTE.DATE_COUNT

FROM

[dbo].[Birthdate] BD

LEFT JOIN

...