Viewing 15 posts - 10,441 through 10,455 (of 13,874 total)
infodemers (9/14/2012)
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...
September 14, 2012 at 6:41 am
raghuldrag (9/13/2012)
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...
September 14, 2012 at 3:16 am
swarnavor-874112 (9/14/2012)
September 14, 2012 at 12:55 am
krypto69 (9/13/2012)
Corp 1984-2005. All rights reserved. Started: 12:30:59 PM Error: 2012-09-13 12:31:00.10 Code:...
September 13, 2012 at 11:22 am
krypto69 (9/13/2012)
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...
September 13, 2012 at 10:23 am
amrashry_1991 (9/13/2012)
September 13, 2012 at 2:39 am
Lynn Pettis (9/11/2012)
September 12, 2012 at 1:48 am
raghuldrag (9/11/2012)
hey friendi am executing dis qury on sql server 2000 only...its not server 2008
I guessed that much from the subject of your post.
Here is...
September 11, 2012 at 7:45 am
sogou34 (9/10/2012)
-------- http://www.chic-goods.us/ -----------hello,This is a wholesaler's web site.
---blah blah
Reported.
September 11, 2012 at 1:39 am
Once again, I have to remind you that this is a SQL Server 2008 forum.
September 11, 2012 at 1:37 am
Lynn Pettis (9/7/2012)
Phil Parkin (9/7/2012)
In her solution, basedata is a CTE - effectively a subquery in this case - from which the normalised...
September 10, 2012 at 9:39 am
Do you mean a folder containing multiple .sql files?
September 10, 2012 at 1:44 am
Surely the Execution Plan would be a better place to start, if performance optimisation is your goal?
September 8, 2012 at 12:11 am
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...
September 7, 2012 at 8:27 am
Please provide some code which exemplifies this. And explain why you need to do this and what you are expecting.
September 7, 2012 at 5:10 am
Viewing 15 posts - 10,441 through 10,455 (of 13,874 total)