Not possible without access to the MS developers.

laurie-789651 (8/1/2012)

---

Having looked at the article, it looks like the 'AS' clause is in the wrong place. It should be like this, I think

SELECT a.DayCount,

...

mrichardson 57577 (7/31/2012)

---

this is working now.

used:

SELECT TOP 100 PERCENT

WebFormData_2.FieldValue AS Surname,

WebFormData_7.FieldValue AS SpecialReq

FROM db.R

JOIN db.WebFormData WebFormData_2

ON db.R.WebFormRowId = WebFormData_2.WebFormRowId

and WebFormData_2.WebFormFieldId =98

left JOIN db.WebFormData WebFormData_7

ON db.R.WebFormRowId = WebFormData_7.WebFormRowId

and WebFormData_7.WebFormFieldId...

Are you trying to boost your points by...

I'm afraid that what you are asking for is not clear enough for me to offer a solution.

Please see the link in my signature for details of how to post...

Mike John (7/31/2012)

---

In your original question you did say the records had to be INSERTED in to the new table, which is what my statement did.

Can you post full DDL...

shahsn11 (7/31/2012)

---

I want that the record in another table i.e in our case emp2 should be overwritten. In my case there can be some records in emp2 which would already...

Following on from Jeff's comment - if you remove the GROUP BY, you should be able to check whether more rows are being returned than you expect/want.

Can you provide us with DDL & sample data that will allow us to replicate this?

ColdCoffee (7/30/2012)

---

I use it mostly to parse out the file names from a long file path. Example:

DECLARE @FilePath VARCHAR(100)

SET @FilePath = 'C:\Users\abcd\AppData\Local\Temp\Temp.txt'

SELECT REVERSE(LEFT ( REVERSE(@FilePath) , CHARINDEX('\',REVERSE(@FilePath))))

Instead of finding the...

Doesn't the execution plan give you any clues as to which index it is using?

Can you describe what the problem is?

One option you can consider is to use Dynamic SQL to script out the "SET part in UPDATE" for the 26 columns

But you have to ignore the computed columns, identity...

Can OdcFlag ever be NULL?

DerbyNeal (7/26/2012)

---

Hi all,

My SQL 'Table1' needs an update to a single column 'STCount'. The update needs to be applied

grouped by 'Sales_Resp', 'Sales_Order', 'Sales_Type'.

So,

'Sales_Resp', 'Sales_Order', 'Sales_Type', 'STCount'

TWells, 123, 4, 0

TWells,...