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.
Author |
Topic |
rjhe22
Constraint Violating Yak Guru
283 Posts |
Posted - 2014-07-18 : 13:17:11
|
hihow can i get this to workDECLARE @FK_DataLoadBatch INT;SET @FK_DataLoadBatch =(SELECT PK_DataLoadBatchFROM DataLoadBatchWHERE Status IN ('In Process')AND LoadType = 'gl')i want to set @FK_DataLoadBatch equal to the number from PK_DataLoadBatchthanks |
|
rjhe22
Constraint Violating Yak Guru
283 Posts |
Posted - 2014-07-18 : 13:19:00
|
its grand its working |
|
|
|
|
|