Some excerpts from BOL (Local BOL)

The ANSI_NULLS and QUOTED_IDENTIFIER options must have been set to ON when the CREATE VIEW statement was executed. The OBJECTPROPERTY function reports this for views...

Bhuvnesh, when u use Indexed Views, u wil have to mandatorily specify WITH SCHEMABINDING.. this also enforeces a rule that that objects tht you access in the view must also...

Hey lee, you may also want to try this

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

DROP TABLE #OFFICE_ASSETS

CREATE TABLE #OFFICE_ASSETS

(

OFFICE_ID INT,

ASSET_NAME VARCHAR(100)

)

INSERT INTO #OFFICE_ASSETS

SELECT 1,'desktop'

UNION ALL

SELECT 1,'printer'

UNION...

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...