Viewing 15 posts - 6,376 through 6,390 (of 49,571 total)
ichayan2003 (3/19/2015)
it is my understanding that we could do the same with left/right join. if not please advice what other option we have, if any
Did you read the articles?
March 19, 2015 at 10:36 am
Dennis Wagner-347763 (3/6/2014)
The correlated subquery may be executed many times. It will be run once for each candidate row selected in the outer query.
I believe that Jeff Moden refers to...
March 19, 2015 at 10:35 am
Katerine459 (3/19/2015)
GilaMonster (3/19/2015)
Katerine459 (3/18/2015)
Unless the CTE is also a correlated subquery, wouldn't it just run onceAnd who said that a correlated subquery doesn't run just once?
I read that here:...
March 19, 2015 at 10:34 am
If the NOT IN works, why do you want to use a LEFT OUTER JOIN?
March 19, 2015 at 9:54 am
There's massive differences between the two. Start with the sections on isolation levels in the SQL Books Online, there's a lot of information there.
March 19, 2015 at 9:54 am
Zohaib Anwar (3/19/2015)
I have same products with same CompanyID's so I cant update CompanyID or product and I need to show them as a single row.
You've got duplicate rows that...
March 19, 2015 at 9:52 am
Zohaib Anwar (3/19/2015)
select * from A INNER JOIN B ON A.ID=B.ID
Please let me know how can we modify above query so that it will gives...
March 19, 2015 at 9:51 am
Zohaib Anwar (3/19/2015)
And I have same CompanyID's...
March 19, 2015 at 9:28 am
No, SQL is not doing a cross join. It's doing an inner join.
When you have duplicate rows then you will see more rows coming back from a join than you...
March 19, 2015 at 9:26 am
No, SQL's giving you an inner join, it's just that your data has every row in one table matching every row of the other table because they're all the same...
March 19, 2015 at 9:15 am
You have to use CREATE TABLE or preferably deal specifically with inserted and/or deleted directly.
March 19, 2015 at 8:29 am
raza.qadri (3/19/2015)
job_order is primary key so always single value:Set @job_order = Rtrim(Ltrim((SELECT job_order FROM #trig)))
No.
If the operation that fired that trigger affected multiple rows, there will be multiple rows in...
March 19, 2015 at 8:17 am
Jeffery Williams (3/19/2015)
This time I am using the EXACT code posted on MS.
Not quite.
Your example: The column you're encrypting you said was varchar(10)
MS's example (using Adventureworks), the column that's being...
March 19, 2015 at 8:11 am
You're creating the temp table twice within the batch. The parser doesn't execute conditionals, it just sees two creations of the same temp table. CREATE TABLE and then insert into.
That's...
March 19, 2015 at 7:55 am
Viewing 15 posts - 6,376 through 6,390 (of 49,571 total)