Hey there, the following code will get you what you want

NOTE : This is not my code, if found it somewhere in this forum; can't remember who coded it. So...

Wow, nice to hear that my code helped you..Pleasure!

Yana, here is the code for you.. But i recommend yout to provide your full table definitions etc etc so that we can give u the best possible code..

IF OBJECT_ID('TEMPDB..#SomeTable1')...

jwellington (4/28/2010)

---

Your answer did get part of the way, but what I need is the detail you have provided as headings to the columns in the view, and then to...

You cant control it that way for INT data-types... Do this instead - Make the column INT, create a CHECK CONSTRAINT on that column to allow only integers from 0...

My poor soul, got lot of free time these days and i am utilizing it to LEARN..:w00t:

Now that said, i have given my time in scripting the code for...

Hi Buddy,how about you going through this following article and helping us help you?? 🙂

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

When u do so, i am sure a...

A year will constitute 12 months. And thats the reason i have done a little tweak to my function. If my code should function as exactly the same as you...

Hey Jus, thanks for posting the DDLs..

Here is a gift for you. This does not perform those 12 SELECT statements, but it still does what u wanted..

Here is the CODE..

ALTER...

ps. (4/27/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...

You're welcome Lee!!

FROM BOL

All base tables referenced by the view must be in...

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