Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2005-07-12 : 14:00:44
|
| hii am having an correlated sub query inside my dts.it's like select 1,.. from (select b.1 ,.. from (select ... from <table name> where <condition> ) a , <table name> b where <condition> ) a , (select from <table> where <condition>) b, where <condition> alike this it's having select statement.may be this is having syntax errors.i just gave the skeleton..i just want to know how can i split this select and execute this one or elsehow it can be explained.since somebody wrote this, i didn't get the meaning.thanks in advance |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-07-12 : 16:33:30
|
| Since you included no specifics or error messages we can't check for syntax errors, or explain what its doing or how its working or why its not working. Read up on subqueries and derived tables in SqlServer Books Online.Be One with the OptimizerTG |
 |
|
|
nathans
Aged Yak Warrior
938 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-13 : 00:59:16
|
quote:
since somebody wrote this, i didn't get the meaning.
Have a Look at Subqueries in BOLMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
subquery