formation of the query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

formation of the query

Author

Topic

susan_151615
Yak Posting Veteran

99 Posts

Posted - 2008-11-21 : 01:02:47

Is the query which i formed is rthe syntax correct can anyone guide me
INSERT INTO
UST_GPA_CHP_STG
(
STG.PAYMENTCODE,
STG.VOUCHERDATE,
STG.HOUSEHOLDID,
STG.PAYMENTCATEGORYCODE1,
STG.PAYMENTCATEGORYCODE2,
STG.PREMIUMPAYMENT,
STG.OLDPREMIUMPAYMENT,
STG.PAYMENTAMT,
STG.ADJUSTMENTEFFECTIVEDATE,
STG.RUNDATE
)
SELECT
PYMT.PAYMENTCODE,
PYMT. VOUCHERMONTH,
PYMT. HOUSEHOLDID,
PYMT.PAYMENTCATEGORYCODE1,
PYMT.PAYMENTCATEGORYCODE2,
PYMT.TOTALPREMIUM,
PYMT. TOTALOLDPREMIUM,
PYMT.TOTALPAYMENTAMOUNT,
PYMT.ADJUSTMENTEFFECTIVEDATE,
PYMT.RUNDATE
FROM
#TMP_CHP_PYMT PYMT,
UST_GPA_CHP_STG STG
WHERE
PYMT.VOUCHERMONTH =STG.VOUCHERDATE
AND LEFT(PYMT.HOUSEHOLDID,9)=STG.SBSB_ID

"here first i concatenated '0' to SBSB_ID" now in this table i want to remove the '0' which i have appended or else i want to take only the first nine characters of HOUSEHOLDID
BUT WHEN I EXECUTE ITstill its showing null value is getting inserted into SBSB_ID (its not taking the first nine characters)

susan

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-21 : 01:36:24

quote:
Originally posted by susan_151615

Is the query which i formed is rthe syntax correct can anyone guide me
INSERT INTO
UST_GPA_CHP_STG
(
STG.PAYMENTCODE,
STG.VOUCHERDATE,
STG.HOUSEHOLDID,
STG.PAYMENTCATEGORYCODE1,
STG.PAYMENTCATEGORYCODE2,
STG.PREMIUMPAYMENT,
STG.OLDPREMIUMPAYMENT,
STG.PAYMENTAMT,
STG.ADJUSTMENTEFFECTIVEDATE,
STG.RUNDATE
)
SELECT
PYMT.PAYMENTCODE,
PYMT. VOUCHERMONTH,
PYMT. HOUSEHOLDID,
PYMT.PAYMENTCATEGORYCODE1,
PYMT.PAYMENTCATEGORYCODE2,
PYMT.TOTALPREMIUM,
PYMT. TOTALOLDPREMIUM,
PYMT.TOTALPAYMENTAMOUNT,
PYMT.ADJUSTMENTEFFECTIVEDATE,
PYMT.RUNDATE
FROM
#TMP_CHP_PYMT PYMT,
UST_GPA_CHP_STG STG
WHERE
PYMT.VOUCHERMONTH =STG.VOUCHERDATE
AND LEFT(PYMT.HOUSEHOLDID,9)=STG.SBSB_ID

"here first i concatenated '0' to SBSB_ID" now in this table i want to remove the '0' which i have appended or else i want to take only the first nine characters of HOUSEHOLDID
BUT WHEN I EXECUTE ITstill its showing null value is getting inserted into SBSB_ID (its not taking the first nine characters)

susan

you dont need the aliases on insert list

also to understand your problem, we need to see data. are you able to prvide us some sample data to illustrate your problem?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources