DYNAMIC SELECT & INSERT QUERY HELP

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » DYNAMIC SELECT & INSERT QUERY HELP

DYNAMIC SELECT & INSERT QUERY HELP

Rate Topic

Display Mode

Topic Options

Author

Message

Kasinathan

Posted Wednesday, February 02, 2011 6:42 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, February 03, 2013 11:35 PM
Points: 12, Visits: 38

HI ALL

PLEASE HELP ME

AM HAVING ONE TABLE LIKE

TABLE1
----------------------------------
CA CB CC CD CE CF CG ..... CN
----------------------------------

I THIS TABLE COLUMNS OR DYNAMIC TABLE..

I NEED TO INSERT THE VALUE IN THIS SPECFIC COLUMNS..

NOW AM INSERING THE VAULE MANUALY.

I NEED TO INSERT THE VALUE DYNAMICALLY

HERE I MENTIONED MY SP SAMPLE

INSERT INTO ##cname (

vchar_Business_Group_Description,
vchar_Sub_Biz_Group_Name,
inte_Emp_Id,
Empname,

CA,CB,CC,CD,CE,CF,CG

)
--
SELECT
vchar_Business_Group_Description,
vchar_Sub_Biz_Group_Name,
inte_Emp_Id,
Empname,
SUM(CA) AS TishmanAccounting,
SUM(CB) AS OtherClientsAccounting,
SUM(CC) AS CentroAccounting,

SUM(CD) AS UnderwritingOld,
SUM(CE) AS StructuredFinance,
SUM(CF) AS SterlingAmericanProperties,

FROM
(SELECT QUERY)

PLEASE HELP ME. ITS VERY URGENT WORK FOR ME.....

THANKS IN ADVANCE

Post #1057441

« Prev Topic | Next Topic »

Permissions