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 |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2007-10-17 : 17:17:41
|
| ok. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-17 : 18:06:27
|
| In order to help you, we are going to need a bit of information. First, provide the DDL statements for all tables involved. Second, provide the INSERT INTO statements for sample data. The data should illustrate what the problem is. Third, provide the expected result set using that sample data.Here's a post of mine where I was asking for help. Notice how quickly I got answers when I provided this information. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42516Please note that usually cursors or loops are not needed. Programmers typically think in terms of loops but databases are designed for set-based approaches.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2007-10-17 : 18:13:43
|
| Moderator or Administrator can you delete this topic? Thanks for the help!!! But Honestly, I don't think I can get any help or friends coming from Michael and Van. So, instead of wasting more time please delete this topic. Also, Michael, I understand we volunteer our time to help others, with a direct and clear answer. People like me with a junior level on sql come to this web site looking for help and a clear answer from experts like you. I don't appreciate the running around and ambiguous answer that just put me behind on my work.Thanks for all the help!!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-17 : 18:20:21
|
quote:
Originally posted by osirisa
Moderator or Administrator can you delete this topic? Thanks for the help!!! But Honestly, I don't think I can get any help or friends coming from Michael and Van. So, instead of wasting more time please delete this topic. Also, Michael, I understand we volunteer our time to help others, with a direct and clear answer. People like me with a junior level on sql come to this web site looking for help and a clear answer from experts like you. I don't appreciate the running around and ambiguous answer that just put me behind on my work.Thanks for all the help!!!
How is my post giving you the run-around or how is it providing an ambiguous answer?I don't see how Van's response in the other thread offended you. You didn't provide a correct answer, so he was letting you know that you can't delete from two tables in the same statement. Joining tables only deletes it from the table in the FROM. So which part of his answer was offensive?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2007-10-17 : 18:21:29
|
| I wasn't taliking about Van--I was talking about Michael. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-17 : 18:22:25
|
quote:
Originally posted by osirisa
I wasn't taliking about Van--I was talking about Michael.
Then you shouldn't mention him in your reply:quote:
Originally posted by osirisa
But Honestly, I don't think I can get any help or friends coming from Michael and Van.
Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-17 : 18:25:35
|
| Now at least I know I've got to quote your posts when I reply in case you are going to remove them. Otherwise my posts aren't in context.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-10-17 : 18:29:14
|
quote:
Originally posted by osirisa
I wasn't taliking about Van--I was talking about Michael.
My first reply in the other thread was to someone else, not to you, so I don't see how what I said was "running around and ambiguous answer that just put me behind on my work". At least I didn't give him a wrong answer like you did.CODO ERGO SUM |
|
|
|
|
|
|
|
|
SQL