infodemers (9/14/2012)

---

Hi everyone,

I have a script task with a validation. On fail, I wish to branch on a Execute SQL Task to send an email and then go to the...

raghuldrag (9/13/2012)

---

Hai friends ,

i ve one doubt in subqueries in oracle

select col1,col2 from @tab1 where(col2,col3) in(select col2,min(col3) from @tab1 group by col2)

while i am executing these...

swarnavor-874112 (9/14/2012)

---

I am using SSIS 2012, to import an oracle table to Oracle, i am working with an 8,00,000+ lacs rows source and destination, the rows already in the destination...

krypto69 (9/13/2012)

---

Here's the error..works fine if a file is there..

Corp 1984-2005. All rights reserved. Started: 12:30:59 PM Error: 2012-09-13 12:31:00.10 Code:...

krypto69 (9/13/2012)

---

I am using this file watcher task:

http://www.sqlis.com/sqlis/post/File-Watcher-Task.aspx

When my user places a file in a directory it fires off and sends the file via FTP.

Works fine, but my question/problem is...

amrashry_1991 (9/13/2012)

---

please guys if someone can help, I'm creating an SSIS package to ftp a file then import it to OLE DB, my problem is, as I want to recieve...

Lynn Pettis (9/11/2012)

---

Plus, we only have part of the problem. We should wait for the other shoe to drop and see how this is going to be used in...

I guessed that much from the subject of your post.

Here is...

Reported.

Once again, I have to remind you that this is a SQL Server 2008 forum.

Lynn Pettis (9/7/2012)

---

Phil Parkin (9/7/2012)

---

Lynn's solution is the way to go.

In her solution, basedata is a CTE - effectively a subquery in this case - from which the normalised...

Do you mean a folder containing multiple .sql files?

Surely the Execution Plan would be a better place to start, if performance optimisation is your goal?

Lynn's solution is the way to go.

In her solution, basedata is a CTE - effectively a subquery in this case - from which the normalised data is being selected.

If...

Please provide some code which exemplifies this. And explain why you need to do this and what you are expecting.