Alias name confused and mind thought it should be right join 🙂

Select M.*,L.Name,L.Company,L.Salary,L.ValidUser, Case when M.ID = R.ParentId then 'Parent' else 'Child' end as Relation

from @Logic L Join @Releation R On L.Id =R.ParentId

Join @master M On M.ID in (R.ChildId,R.ParentID)

Batch process means SSIS package ?

If you are using SSIS, recently I came across a situation that extracting data using a view from SSIS slower but running the same view...

Great explanation Hugo. Thanks.

Even I always use COUNT(1) though few times I heard both COUNT(*) and COUNT(1) are same. But today I more clear and thanks for you.

🙂

Hugo Kornelis (4/16/2013)

---

Good question, mediocre explanation - no errors, but complicating things more than needed.

There are three variations of COUNT:

* COUNT(*) - returns the number of rows, regardless of content.

*...

Nice one Chris..

I Understood (Hope) the requirement after seeing the query from Chris... Still not able to bring all the rows.. Not able to get the ID's doesn't have any...

Yes as Vinu said we need a relationship between Term and Attend.

I have tried the below query and it is not exactly matching your requirement but it might help you...

Select...

Hi,

You can achieve this with Pivot as well..

SELECT Certyear, [HI-Master] , [HI-Instr] , [HI-Train]

FROM

(SELECT Certyear,CertCode,Quantity FROM Certification) C

PIVOT ( SUM (Quantity) FOR CertCode IN ( [HI-Master], [HI-Instr],...

Hi Ananda,

First delete statment can be done using a CTE like below...the below code might not exactly work for your requirement, please test it with select to match the count.

;with...

Nice Question.

SELECT * FROM tempdb.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE '#TempQoD%'

It will make effect Kapil. Try the below...

As in the explanation the scope is only within the EXECUTE statement.

USE master;

-- Query#1

SELECT DB_NAME() DatabaseName1;

EXECUTE ('USE AdventureWorks2008; SELECT DB_NAME() DatabaseName2');

-- Query#2

SELECT DB_NAME()...

demonfox (1/27/2013)

---

Ya , without...

+1

+1

I wanted to see the answer and explanation without spending time in analyzing and...

Nice Question. Learnt something for today.