Thanks - this does work !

The only problem I have with dynamic is that it gets real messy when you have a lot satements included in the same query like...

This is a sample of the code I will have this month and the code after for next month.

The number of months I have is 61 so I will have...

Yes - I set the percentage for testing.

I want to set the Field name Month1 to

Month2 next month within the Query but I do

not want to retype all Month1...

Here is the error message

Server: Msg 194, Level 15, State 1, Line 23

A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.

I tried the @name1 = Month1 but it said it was not allowed to be set in a select into.

I am trying to assign the Value in Month1

to a variable...

Thanks for the Post.

Rocko.

Thanks Guarddata - that work Great !

I appreicate the current and past post .

Rocko

Can you set field size within this table create ?

Thanks for your help. Rocko

Here is the code. When I look at the table that is created it has varchar set to 8000.

SELECT Distinct

TOP 100 PERCENT

[Vin 8],...

The [WILD CARD] field in the table that is created shows a filed size of 8000 varchar

I do not know wht it does this - I wanted to know if...

I have this logic that I create the field called [WILD CARD]. The table that I create with the Query has an output of 8000 varchar.

Can I add the output...

Thanks.Rocko

Thanks Jpipes. Rocko

Here is an example. I want to have two fields as primary keys. Do I just add

Primary key as stated ?

SELECT distinct

TOP 100 PERCENT

[Client...

Thanks jpipes !!!!!!!!!!!

That works great !!

Rocko