stored procedure required - 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

SQL Server 2005 Forums

Transact-SQL (2005)

stored procedure required

Author

Topic

rajasekhar857
Constraint Violating Yak Guru

396 Posts

Posted - 2009-08-05 : 02:07:43

[code]
SP_HELP EMRTPB

COLUMN_NAME TYPE

BILL_ITEM_ID numeric
TP_ITEM_ID varchar
BILL_SVC_TX_ID numeric
APPOINTMENT_ID numeric
PATIENT_ID varchar
CONSULTANT_ID varchar
CONSULTANT_TYPE varchar
ITEM_NAME varchar
ITEM_DESC varchar
ITEM_TYPE varchar
ITEM_QUANTITY varchar
LINE_NUMBER varchar
LOCATION_ID numeric
GROUP_ID numeric
MODIFIED_DATE datetime
IS_TP_APPOINTMENT numeric
PACKAGE_ID numeric
TP_BILL_NUMBER varchar
APPOINTMENT_IDS varchar
LAST_UPDATED_DATE datetime
LAST_UPDATED_USER varchar

SP_HELP EMRAPP

COLUMN_NAME TYPE

APPMT_TX_ID numeric
APPOINTMENT_ID numeric
HL7_DATA varchar
USER_ID varchar
REG_RESPONSE varchar
FLAG_ID varchar
TRANSACT_DATE datetime
STATUS numeric

MAPPING CASE COLUMN--------------APPOINTMENT_ID.

1.NOW I WANT TO HAVE A STORED PROCEDURE ON THIS LIKE
AS APPOINTMENT_ID,STATUS,FLAG_ID FROM EMRAPP SHOULD COMBINE WITH EMRTPB ON ALL COLUMNS

2.IF FLAG_ID=001 AND IS_TP_APPOINTMENT=0 THEN UPDATE TP_BILL_NUMBER

3.IF FLAG_ID=008 AND IS_TP_APPOINTMENT=1 THEN UPDATE TP_BILL_NUMBER

[/code]

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-08-05 : 10:45:30

>>SHOULD COMBINE WITH EMRTPB ON ALL COLUMNS
sorry, I don't know what you are asking for.

http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources