Hi there, you need a cross-tab query

SELECT

Tone,

SUM(CASE WHEN IsIncomming=1 THEN Duration ELSE 0 END) AS [IsIncomming = 1],

...

You'll need to add a WITH ROLLUP to a GROUP BY

///Edit - sorry, excuse me, Little Sir Echo

Hi, you need to create a stored procedure, see http://msdn.microsoft.com/en-us/library/aa258259(SQL.80).aspx

Did you look at my suggestion of full text catalog at all?

Heh he, you're quite right :blush:, guess he'd need to normalise as per your solution, take a distinct on the resultant item table, then concatenate with XML FOR PATH method...

I would also recommend that you go with Lynn's solution - this kind of un-normalised view should only really be used for display. In the interests of completeness, if...

Hi,

I just tested a SSIS import of a Foxpro free table, with integer and logical fields, both nullable. I added a few rows of data leaving a few fields...

How is it not working?! Are you getting an error? Are you not getting the results you are expecting?

The query will need a LEFT JOIN

It ain't just less code, it's faster too. And yeah, internally SQL server does have to go row-by-row, but that's faster than an explicit while loop.

Have a...

Just out of interest, how was this being done in the Foxpro app? Using a while loop, indexseek and replace?

Hi,

you can do this with following:

UPDATE TableB

SET Value2 = A.Value1

FROM TableA A --Using 'A' as alias for TableA

WHERE

ID2 = A.ID1

AND...

Cool, well do you fancy posting ddls, data, query and output for the TableA TableB RBAR you refer to above?

Ah, go on!

Yeah,

definitely plan carefully on this one, learn to avoid RBAR (almost every time) and you'll be totally astonished by performance gain.

Even if you don't avoid bad habits problems may be...

Jan Van der Eecken (8/1/2009)

Jack Corbett (8/1/2009)

Jeff Moden (8/1/2009)

I...