DAMN!!!...I STILL DON'T KNOW WHAT PORK CHOP HAS TO DO WITH SQL. and it is alright that Microsoft Certified Master MVP be wrong once awhile, just like Microsoft once was...

For the OP solution this seems one of those times it would actually be ok to use select *. The very challenge is due to changes in the source table...

Alright guy,my bad! I didnt intend to use "select * into" anyway, I was lazy typing so just threw out a quick post that caused someone hair stands...

I just thought of a solution after posting:

--dump existing data from target table into a temp table

select * INTO #TempTable from TargetTable;

--drop the TargetTable

drop targetTable;

--recreate TargetTable with additional fields from...

If it is the first time you think of...

Jeff Moden (10/30/2012)

---

haiao2000 (10/29/2012)

---

Saying I...

Eric M Russell (10/29/2012)

---

Instead of calling the job explicitly, you could have a job that runs every five minutes or so, polls a table to see if any works needs...

Saying I have a SQL...

I thought about this too....

Got You! I have been using sp_executeSql, Just want to see if there is a way that I dont know of.

thanks!

GSquared (10/25/2012)

---

Nope. SQL doesn't work that way.

Look...

it sounds like the exact oposite is true (again it depends) but take the examples below

method #1

create procedure SP1

@p1 int

,@p2 int

,@p3 int

,@p4 int

as

select * from SomeTable

where p1=@p1...

Sean Lange (10/22/2012)

---

harri.reddy (10/22/2012)

---

well,

they gave me some tables(approx 9) tables and field that they want to fecth only those field.

they all r master table.so do i need to make table...

Jeff,

Thank you for all the hard works on this. I hope I would have let you know this in advance so you didnt waste your time on this. I have...

Luis Cazares (10/17/2012)

---

Please test the solution, I might have made a mistake.

declare @Temp table(state varchar(50),county varchar(50), city varchar(50),Action varchar(50), ActDateTime DateTime)

insert into @Temp(State,County,City,Action, ActDateTime)

select 'Texas','Harris','Houston','Census Taken','11/12/2010 00:00:00' Union...

Oh well here is one of the solution. If you have a faster solution, I would love to know it

Thanks!

declare @Temp table(state varchar(50),county varchar(50), city varchar(50),Action varchar(50), ActDateTime...