You are going to need to use dynamic sql to generate the query you need to run using system tables to identify the column names for the table requested.

I don't...

parthi-1705 (4/18/2011)

---

Lynn Pettis (4/18/2011)

---

Why all the function calls?

select

'id: ' + id + ';' +

'name: ' + name + ';' +

...

parthi-1705 (4/18/2011)

---

Is this you need

create table #Temp (id int,name varchar(30), surname varchar(30) ,age tinyint)

insert into #Temp values (1, 'John', 'Smith', 20)

insert into #Temp values (2, 'Pen', 'Drive', 14)

Select COL_NAME(OBJECT_ID('#Temp'),...

May I ask why you need this?

I believe what you are looking for is this:

create table #TestData (

project char(3),

country varchar(64),

vendor char(4),

...

Mirror, mirror on the wall tell me please what is wrong!

Here is the problem, we can't see from here what you see from there. We have no idea what the job is doing that fails, we have no idea...

Just a guess, but I'd be checking the server logs and talking to your network people.

This doesn't look like a SQL Server specific error.

SanDroid (4/12/2011)

---

Tom.Thomson (4/12/2011)

---

At this point there is...

SanDroid (4/12/2011)

---

You still haven't proven your point. I still see nothing in the code above that supports your position regarding the version store. I have also gone back through the...

SanDroid (4/12/2011)

---

Lynn Pettis (4/12/2011)

---

SanDroid (4/12/2011)

---

Lynn Pettis (4/12/2011)

---

Bottom line, your stating your interpretation of the support information isn't enough. Support your position with code, hard data from the DMV's, output...

SanDroid (4/12/2011)

---

Lynn Pettis (4/12/2011)

---

Bottom line, your stating your interpretation of the support information isn't enough. Support your position with code, hard data from the DMV's, output from t-logs (yes,...

SanDroid (4/12/2011)

---

Lynn Pettis (4/7/2011)

---

For the record, I missed this one too.

I also found SanDroid and his arguments most interesting, if not totally off in left field somewhere. It is...

Craig Farrell (4/12/2011)

---

paul.knibbs (4/12/2011)

---

The article this...

djackson 22568 (4/11/2011)

---

Lynn Pettis (4/11/2011)

---

I did a campus visit with my daughter to Embry Riddle Aeronautical University in Prescott, AZ. The washers and dryers in the laundry area in...