Just a suggestion to try, I can't tell if you tried something like this or not:

select tr.[GUID]as gid,[EP_NO],[NAME],

[CONTRACTOR_CODE],[CONTRACTOR_NAME],

[SUBCONTRACTOR_NAME],[PLANT_CD],[SKILLCODE],[WORK_AREA],

[DISCIPLINE],[PASSTYPE],[PRES_ADD],[PRES_VILLAGE],

[PRES_TALUKA],[PRES_DISTRICT],[PRES_TEHSIL],[PRES_CITY],

[PRES_STATE],[PRES_PIN],[PRES_TEL_NO],[FATHER_HUS_NAME],

[DT_BIRTH],[DT_JOIN],[EP_VALID_TILL],[LICENSE_NO],

[GENDER],[BLOOD_GROUP],[RELIGION_CD],[ID_MARK],[HEIGHT],

[DT_LEAVE],[COMMENT],[STATUS],tr.[ENROLLTIME] as EntTime,

tr.[OPERATORID] as OptID, [MODIFY_DT],[CONTRACTOR_TYPE],[WORKAREA_CATEGORY]

-------------------------- put the 'into' here --------------------------------- <<<<<<<<<<<<<<<<<<

INTO NEW_TABLE_NAME_HERE

--------------------------...

suba.sathyanathan 40131 (10/18/2012)

---

Hi Peter,

Information_Schema.Tables is a system view. It is available as part of all sql server databases. Kindly let me as to which version of sql server you are...

True! I...

L' Eomot Inversé (10/19/2012)

---

Maybe some programmers, but other programmers consider the statement

that SQL Server doesn't correctly manage the size of tempdb to be either incorrect or at least...

Hugo Kornelis (10/19/2012)

---

Very good question overall.

Only (minor) issue - picking 6 out of 17 answer options is a task that appears daunting at first sight. The answer options were luckily...

Vegard Hagen (10/18/2012)

---

Yes, I did - and you knew exactly what you were looking at, but the other guy said it "looked like" something, so I gave him a resource...

If your operator is logging into a windows domain on the computer with the internet explorer they're using to view ssrs reports, you can make use of the "built in...

arthur.gimpel (10/15/2012)

---

patrickmcginnis59 (10/15/2012)

---

The posted code wasn't formatted very well so wasn't able to read it without significant editting and it wouldn't run either (I only tried selected snippets from it...

The posted code wasn't formatted very well so wasn't able to read it without significant editting and it wouldn't run either (I only tried selected snippets from it ot verify...

Lokesh Vij (10/10/2012)

---

I was hoping this too....Not every one got it correct!

Correct answers: 75% (9)

Incorrect...

I reran the little vb snippet with op3's original 1000000 row test, and while it started returning rows, THIS time when I control-c'ed, no rows updated. I do realise that...

This is an interesting one. I found some vb.net code that would read from a connection a row at a time and fed it the update statement. I control-c'ed after...

jshahan (10/2/2012)

---

I thought of another way to say it that helps me. The triple quotes maintain a string as a string. The single ones become part of the...

You're welcome and good luck!

jshahan (10/2/2012)

---

Thanks, Patrick

Are you saying that the quotes function like escape characters and that handling of the escape characters is dependent on which clause they are in? EXEC wants...