This may help you

SELECT

X.*,Y.*

FROM USERMAST X

CROSS APPLY

(SELECT COUNT(*) CNT FROM USERMAST Y WHERE X.USERID=Y.PARENTID) y

Try this

select * from tab1

order by id

Try below Query

SELECT qdb.xDate,

sum(case when t.TempSymbol='AAPL' then qdb.xClose end) 'AAPL',

sum(case when t.TempSymbol='AMD' then qdb.xClose end) 'AMD',

sum(case when t.TempSymbol='MSFT' then qdb.xClose end) 'MSFT'

FROM StockQuote qdb

INNER JOIN #TempSymbolList...

Try like

select

case when STAT='O' and dormant='N' and code='200' then 1 esle null end active,

case WHEN OPEN_DATE BETWEEN '7-MAY-2012' AND '31-MAY-2012' and code='200' then 1 else null end...

Can you tell me what is use of statment

nice question, good leaning.

Logical Processing Order of the SELECT statement

http://msdn.microsoft.com/en-us/library/ms189499.aspx

Use SSIS Package

1. Develop SSIS package to extract the data in csv/text file

2. Copy the csv/text file on second server (using FTP or some other method upto you)

3....

U can also Write your query with out cursor like

select

p.*

,t.FullName

from plan p

cross apply

(select FullName from part pp where p.name=p.aeroplane_name) t

Use OUTPUT parameter

No, Trigger not returns any data.

Regards,

Srikant

Use Case statment

SELECT EmpName As EName

case when BasicPay>5000 then 'OVER else 'lOW' end AS Result

FROM EmpSalary

Try this

CREATE TABLE #temp (id int identity,AgencyID int,GroupID int )

INSERT INTO #temp

(

AgencyID

,GroupID

)

SELECT

-- V.y.value('(//AgencyID)[1]','int') AS AgencyID

V.y.value('.','int')

,@GroupID

FROM @Agency.nodes('/Agency/AgencyID') AS V(y)

SELECT * FROM #temp...

Try This SQL

create table student ( stdnt_id int, stdnt_name varchar(50),stdnt_activity SMALLINT )

go

INSERT INTO student

select 1, 'kiran', 5 UNION ALL

select 1 ,'kiran', 10 UNION ALL

select 1 ,'kiran', 15...

Use expression to hide the column. Set the expression on column property