can anyone tell me why first value without quotes will gives the error hile the value without quotes not giving any error...

easy onee 😛

Nice question 🙂

if I used asc in Order By clausethen it will return only 1 row.. it will return 3 rows when there is desc in order by clause..

why is it so?

Jeff,

I dont have any idea about dynamic SQL so can you plz help me in this...

Nice question to start week with +1 🙂

Good Question..

Before giving answer I first read about WITH Schemabinding ON abd got to know that table name that we use in view statement should be wirte using schema...

Nice and clean question..

Good discussion 😛

Nice Question..

There is one more link if anyone want to read about LEAD :

[/url]

Nice explanation John...

I dont have SQL Server 2012 but learned a new intresting thing.. 🙂

Thanks Danny 🙂

Jason,

the new columns that you created 'Compare1' and 'Compare2' are not using in where condition so, how the condition is creating to match those columns?

Jason,

I run your without making any changes and get the following error:

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the nvarchar value '1-1 ...

Jason,

I have changed my query as:

SELECT

(

PP.IsPatient = P.Fpatient,

PP.Gender = P.Fsex,

PP.MartialTypeID = P.Frelation,

PP.Lastvisit = P.Flastvisit,

PP.NxtVisit = P.Fnextvisit,

PP.LastTxNumber = P.Flasttxno,

PP.OldAcct = P.fOldAcct,

pp.ClaimGroup = P.fClaimGroup,

PP.ConsultDate = P.fConsultDate,PP.usedby=P.Fusedby,

PP.IsDeleted = P.Fdelete,

PP.CreatedDate = P.Fwhen,

PP.TrojanId = P.fTrojanId,

PP.PreferMtd...