Forum Replies Created

Viewing 15 posts - 16 through 30 (of 74 total)

  • RE: complex query

    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,...

  • RE: Query Execution Plans & Recompilation

    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')

    ...

  • RE: Index

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

  • RE: Index

    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...

  • RE: Index

    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...

  • RE: Index

    Thanks a lot Gail...

  • RE: complex query

    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...

  • RE: complex query

    /****** 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)...

  • RE: complex query

    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...

  • RE: updating a column

    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...

  • RE: Need help combining two queires

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

  • RE: updating a column

    Hi Grant.

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

  • RE: Memoey Spce Issue

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

  • RE: updating a column

    thanks a lot gail....

  • RE: Inserting Multiple Rows in SP

    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

Viewing 15 posts - 16 through 30 (of 74 total)