|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
[TCP/IP Sockets]ConnectionCheckForData()) Error
Error was returned when we compiled a proc. The proc compiles under SP3a.
We're using Standard Edition SP4. The offending statement is a sub-select in a where clause that uses a union: and mv.INSTR_ID in ( select @INSTR_ID union select ridf.INSTR_ID from FT_T_RIDF ridf join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @INSTR_ID where ridf.REL_TYP = 'OPTION' ) change to:
( select @INSTR_ID AS [ID] union select ridf.INSTR_ID from FT_T_RIDF ridf join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @INSTR_ID where ridf.REL_TYP = 'OPTION' ) -- Show quoteHide quote-oj "davidhg" <davi***@discussions.microsoft.com> wrote in message news:3255283F-3B9E-435B-BFC4-51CF9B5069BD@microsoft.com... > Error was returned when we compiled a proc. The proc compiles under SP3a. > We're using Standard Edition SP4. > > The offending statement is a sub-select in a where clause that uses a > union: > and mv.INSTR_ID in > ( > select @INSTR_ID > union > select ridf.INSTR_ID > from FT_T_RIDF ridf > join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID > and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @INSTR_ID > where ridf.REL_TYP = 'OPTION' > ) > > Hi oj,
Unfortunately, the error still occurs. To compile the proc, we created a pseudo-talbe from the sub-select with the union statement and joined it directly to the other tables. FYI, I opened a case with MS. -- Show quoteHide quoteDave "oj" wrote: > change to: > > ( select @INSTR_ID AS [ID] > union > select ridf.INSTR_ID > from FT_T_RIDF ridf > join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID > and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @INSTR_ID > where ridf.REL_TYP = 'OPTION' > ) > > -- > -oj > > > "davidhg" <davi***@discussions.microsoft.com> wrote in message > news:3255283F-3B9E-435B-BFC4-51CF9B5069BD@microsoft.com... > > Error was returned when we compiled a proc. The proc compiles under SP3a. > > We're using Standard Edition SP4. > > > > The offending statement is a sub-select in a where clause that uses a > > union: > > and mv.INSTR_ID in > > ( > > select @INSTR_ID > > union > > select ridf.INSTR_ID > > from FT_T_RIDF ridf > > join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID > > and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @INSTR_ID > > where ridf.REL_TYP = 'OPTION' > > ) > > > > > > > Okay. Without seeing the *whole* thing I'm not sure what would be the case.
The syntax looks right to me. Do post back if you hear anything. -- Show quoteHide quote-oj "davidhg" <davi***@discussions.microsoft.com> wrote in message news:21FFCFE8-EED9-47FA-821C-AE224C630FDC@microsoft.com... > Hi oj, > > Unfortunately, the error still occurs. To compile the proc, we created a > pseudo-talbe from the sub-select with the union statement and joined it > directly to the other tables. FYI, I opened a case with MS. > -- > Dave > > > "oj" wrote: > >> change to: >> >> ( select @INSTR_ID AS [ID] >> union >> select ridf.INSTR_ID >> from FT_T_RIDF ridf >> join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID >> and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @INSTR_ID >> where ridf.REL_TYP = 'OPTION' >> ) >> >> -- >> -oj >> >> >> "davidhg" <davi***@discussions.microsoft.com> wrote in message >> news:3255283F-3B9E-435B-BFC4-51CF9B5069BD@microsoft.com... >> > Error was returned when we compiled a proc. The proc compiles under >> > SP3a. >> > We're using Standard Edition SP4. >> > >> > The offending statement is a sub-select in a where clause that uses a >> > union: >> > and mv.INSTR_ID in >> > ( >> > select @INSTR_ID >> > union >> > select ridf.INSTR_ID >> > from FT_T_RIDF ridf >> > join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID >> > and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @INSTR_ID >> > where ridf.REL_TYP = 'OPTION' >> > ) >> > >> > >> >> >>  
Other interesting topics
Restoring master and msdb on a different server
MS Access Query vs. SQL 7 Stored Procedure MS PSS-What the heck is this?! Basic question.... on Index.... Problem with osql.exe -L full drives full trans log version 7 alter table drop column and dbcc cleantable SQL7 2 DB files down to one??? SQLServer Agent varchar vs nvarchar |
|||||||||||||||||||||||
