Jamsheer (9/24/2013)

---

Good and easy question. Helped to have some thoughts about CTE and stated some points.

** CTE is a 'reference' to the source tables. i.e. Any changes to CTE will...

No it will not give as GO is there...

Remove the GO and try you will get...

Sorry I cant disclosed that but the columns using in join all have index on them

I thought due to cross join performance issue is there so I rewrite the query in this manner:

SELECT

A.OFFICEID,

A.PROJECTID,A.PROPOSALID,A.SOLUTIONID,A.UNITID,A.PRICEITEMID,A.ESTIMATIONGROUPID,A.SRNO,A.PRICEITEMNAME,A.LOCALPURCHASETYPEID,A.PRI_PRICE,

A.Sec_Price,A.PRI_PRICEWOR,A.SEC_PRICEWOR,A.PRIMARYCURRENCYID,A.SECONDARYCURRENCYID,A.DELETEFLAG,A.DATEADDED,A.ADDEDBY,A.DateChanged,A.ChangedBy,A.Quantity,

A.SrNoDetail,A.Pri_PriceWM,A.Sec_PriceWM ,A.Code,A.MOrIType

FROM ESTIMATIONOUTPUTPRICE A WITH (NOLOCK)

inner JOIN VW_ESTIMATIONOUTPUTPRICE_ETL_COMPANY B WITH (NOLOCK) ON

A.OFFICEID...

What error you are getting?

While using SELECT it will give the output in a commented lines while using EXEC it gives the error :crazy:

declare @var Varchar(1000)

set @var = '-- /* select ''Samith'' name

*/'

select...

you can create a SQL job for this

spectra (9/23/2013)

---

I have two columns Student_ID and MAC_ID in my table.

I want to put Unique constraint on these two columns together.

I am using SQL Server Management Studio...

Instead of this:

SET @SqlQueryFirstName = '@SqlQuery ' + 'firstname = @firstname'

Write this:

SET @SqlQueryFirstName = @SqlQuery + 'firstname ='+ @firstname

etirem (9/21/2013)

---

The Groups are created based on CDate and Dept.

For the CID, the CDate is in ASC order and if Dept=C and the next row is Dept=C...and next row is...

may be the value you are passing to the variable @table is greater than varchar(10) which results in string truncation..

please check this

the information you have provided is not complete..

can you please tell us on what basis you are creating the groups?

enriquezreyjoseph (9/19/2013)

---

Thanks you my friend....

yeah you are right...i forgot to put set...i put it already and it give me this error

--------------------------

Msg 102, Level 15, State 1, Procedure SaveBiography, Line 70

Incorrect...

what are you trying to do?

can you please post some sample data and what you want as output from that sample data?

what questions?