Yes, but the table must already exist..

So you have to create it prior to: insert <table> exec <proc>

/rockmoose

Yes,

Insert [#][#]Table Exec Proc

BUT, the table must already exist and have the same structure as the output of the Proc.

/rockmoose

" But my question is , is there any possbility by TSQL code  to alter the

table with "Identity" property."

You can only add a new column with the identity property to...

Fellow posters,

First I can state that I am for stored procedures.

You can percieve of the database as "only" a storage media for your data, and let the client application handle...

Nice, thank You sqluser.

A source control system could probably accomplish the same thing.

/rockmoose

What is the ONE business case you are thinking of ?

Curious.

/rockmoose

There is an example in BOL. see: "expanding hierarchies".

There are other 'better' ways of doing this, submit some test data and an example of what you want your result to...

3) Yes, it is possible to achieve duplicate values in an identity column.

But not if the identity column is a primary key or has an unique index defined on it.

/rockmoose

Take a look at this FAQ:

http://www.sqlteam.com/item.asp?ItemID=986

/rockmoose

You might consider creating a permanent table

create table final(a float, b smalldatetime)

and keep this current whenever the data changes.

This way the underlying proc would not need to recreate the temporary...

Hi,

Do You have appropriate indexes on the table ?.

And what is the Primary key on the table ? - ( is job_loc + client the pk ? )

From the query...

Yes you are right, the code uses a couple of unusable standard date functions.

Just came home from vacation and the brain maybe is still on vacation 🙂

Here is an interesting...

From performance reasons you want to have indexes on the table.

( but probably not 84 or 124!, which columns are searched )

Why 1 big table ?

How do You present the...

Ok, forgot to add..

For performing datediff comparisons and such ( day level ) you just have to substract the id between 2 dates in the sample table.

You could add constraints...

My suggestion is to create a separate table to hold the sequence of dates you are interested in.

All tables that contain calender information will then reference this table on the...