SQLkiwi (3/4/2011)

---

Once you've read that article, this code should make sense:

SELECT CONVERT(VARCHAR(12), Emp.empno) + ' | ' +

STUFF(CA1.marks.value('./text()[1]', 'varchar(max)'), 1, 1,...

Hai...

if i execute a procedure as my code starts as follows...

PROCEDURE PROC_SY_ADD_INSERT_FUNCTION

GO

IF EXISTS (SELECT * FROM sysobjects

WHERE id = OBJECT_ID('PROC_INS_FUNCTION')

...

Oh.... thanks gail.. thanks a lot...

i couldnt upload the sql plan file due to server problem...

i m posting my queries.

Query 1:select a.ACCESS_ID as accessId,a.ROLE_ID as dmsRespId,a.USER_ID as dmsUserId,

(select NAME as wfRespName From HR_JOBS yy where...

With this one i attached two image files which depicts two execution plan of 2 queries which gives same results. which execution plan is better one.. how to calculate the...

Thanks a lot Gail...

it is solved...:-)

it's the problem of having different collation in column level. i just dropped the table(after taking backup of data). created again.. now it works properly..

Thanks a lot...

/****** Object: Table [dbo].[HR_COMPANY_HEADER] Script Date: 01/22/2011 12:59:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[HR_COMPANY_HEADER](

[COMPANY_ID] [int] IDENTITY(1,1) NOT NULL,

[TRADE_NAME] [varchar](50) NULL,

[COMMERCIAL_ACTIVITY] [varchar](50) NULL,

[GENERATE_RESERVATION_DOCUMENT] [char](1)...

Hi,,

Thanks a lot..

As u said i followed.. but i am facing new problem..

select case com_owner.owner_type

when 'Company' then com_header.trade_name

when 'Person' then per.first_name end

from hr_company_owner com_owner

left...

Exactly my requirement is more or less same like what tfifield mentioned.

And Jeff. i cant use AUTO INCREMENT for that column as it is requirement.

So i go with...

Can u provide sample table relevant to ur problem?.. so that it wil be easy to help out

Hi Grant.

yes. i am doing this for generating unique number. Thanks for ur valuable info.

Thanks a lot..............

thanks a lot gail....

Hi..

According to me following query is best possible way to insert mulitple record in a table....

insert into table2(col1,col2) select col1,col2 from table1 where session_id=1