sql server db

Wonder if anyone can help If I wanted 2 Values from a Correlated Subquery (same table join etc) would i have to have 2 subqueries or is ther...

Hi, Correlated subquery is written in the following syntax in Oracle. Select Ename,Sal from Employee X where 5= (Select count(distinct(sal))...

Can you use a correlated subquery in a join expression, when you reference the table your joining to? Hi Ben An example of what you are tryi...

Can you use a correlated subquery in a join expression, when you reference the table your joining to?Hi Ben An example of what you are tryin...

Hi there, I want to do something very simple, but in the most efficient way possible. Let's say I have these two tables: tblContacts(con...

I need to loop through several rows and find matches for values and the aggregate a different column. Being a VB type and not as much the s...

I need to loop through several rows and find matches for values and the aggregate a different column. Being a VB type and not as much the sq...