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,...

Personally, I'd stick with OLEDB.

You might like to read this[/url] for attempts at comparisons.

In your dataflow, add a Conditional split to split the data stream into three outputs.

Each of the outputs will go to its own file destination.

Sean Lange (7/25/2012)

---

Phil Parkin (7/25/2012)

---

Nice article - thanks for the link. When I read absolutes (like 'meaningless') my brain subconsciously challenges them. I still think it was the wrong word...