Thursday, 5 September 2013

.* afters t-sql statement in SQL server 2008

.* afters t-sql statement in SQL server 2008

I have problem with following statement. Could you tell me what is EMD_1.* ?
WITH EMD as (
SELECT
,attribute1
,attribute2
,attribute3
,ROW_NUMBER() OVER (PARTITION BY attribute1
ORDER BY attribute3) as _RN
,attribute4
,attribute5
FROM
table_name1
)
select
EMD_1.*
,isnull(EMD_1.attribute1,'_profitcenter nd') as ProfitCenterName
,EMD_1.attribiute2 as PC_ID
FROM
EMD as EMD_1
JOIN
table_name2

No comments:

Post a Comment