Although I'm not sure why you would want to do this there is a way. You can create a stored procedure which calls your exec('create view...') statement.

create...

Do you have the option to temporarily map an external drive and set the tempDB to use that drive during this process?

If you are using a UNION instead of a UNION ALL that is a performance hit as well. UNION returns distinct rows of data so you have to deal...

Look into OPENDATASOURCE in Books Online. That should get you started

Another interesting point, if you modify the query like this:

select P.fldYear as JIMMY, cast(P.fldYear as varchar) +

case when P.fldStage > 2 then ' Final' else ' Initial'...

Jeff, quick question. Since I used a clustered index couldn't I "assume" that the order would be as I want it?

I know to never assume...

ST

Ah, very cool indeed.

Thanks

Gail, I'm confused as to why to use the datediff function.

declare @dt datetime

set @dt = '1/31/2008'

-- 2 months out

-- Note that this adds 2 to the...

I knew I remembered a way to do this with variables!

Credit where it's due, Jeff showed me this a while ago. It took me a while to remember it.

set...

Is this a better approach, Jeff?

set nocount on

set statistics io on

set statistics time on

-- Drop if necessary

drop table #tbl

create table #tbl (IID int identity(1, 1), num int)

create clustered index tmpIndexIID...

Ashwin M N, please forgive the flames but it had to have taken you longer to write that the answer didn't match your requirements than it would have taken for...

create table #tmp (fldID int identity(1, 1), fldNum int)

insert into #tmp (fldNum)

select 1 as x union all

select 2 as x union all

select 3 as...

Ken is correct. I apologize that my original queries were incomplete. Here is a query which demonstrates my point:

set statistics io OFF

set nocount on

CREATE TABLE #foo (

...

Unfortunately it did need tableA in the two sub queries. As I was posting pseudo code I didn't include the many other joins in the sub queries. I...

Thanks, Jack. I have lots of options as to how to correct the issue. I was interested in a discussion as to why the query would create the...