Oh boy :blush:!! Thanks...

Happy that my code helped you..

As for your error, you are trying to concatenate INT value to a VARCHAR variable.. To negate his error , we will have to...

Hey Jus, can you please post sample data for tblPeriod (in tthe form of INSERT INTO TABLE <> SELECT statments) ?? This will be very helpful to revamp the query...

~Edit: Code removed - Better version of this is posted in the next post of mine

Cheers!!

Gianluca Sartori (4/27/2010)

---

It's a "trick" to generate on the fly a string with concatenation of all...

FOR XML PATH concatenates the rows values present in the column which you want to become as...

Gianluca Sartori (4/27/2010)

---

Aaah! You fell victim of the "google translator" bug!

I think you wanted to translate "You're welcome", that's "Prego" in Italian.

"Sei il benvenuto" means...

Jason, you could have closely followed either mine or Gianluca's code and with further modifications, you could have accomplished the task..

But anyways, here is your code

First, the table structure (teh...

Alessandro, Sei il benvenuto!

Gianluca, you beat me to it 😎

And Alessandro, as he said convert the bit column into tinyint (i used INT though) and then you can aggregate..

Cheers!!

hey buddy, i did not understand fully your requirement, but i have a pivot query which might interest you..

SELECT datax , [1] StatoImp1, [2] StatoImp3, [3] StatoImp3 FROM

...

Buddy, can you be more specific with your requirement??

Please go through this following article and helping us help you?? 🙂

CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

When u...

Buddy, can you be more specific with your requirement?? i mean, why do u wnat to compare the InvoiceDate and StartDate and then again using the same combination to filter...

Hey Gerald, as promised , here is mini-version of the dynamic update query.. It is just a starter, you will have to build up on the start and customize it...

Lynn Pettis (4/26/2010)

---

Looks just as easy with a CTE:

with GroupData as (

SELECT

Key1,

MAX(VAL1) as MAX1,

SUM(VAL2) as SUM2

FROM

...