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 |
kabon
Starting Member
48 Posts |
Posted - 2013-03-27 : 03:06:50
|
can i use script select where in and not in together?for example :SELECT REPLACE(B.[Column 0] COLLATE Latin1_General_100_BIN2 ,LEFT(B.[Column 0],CHARINDEX('.',B.[Column 0])-1),isnull(C.T24_ID,LEFT(B.[Column 0],CHARINDEX('.',B.[Column 0])-1)))from LDTLTXT_20130314 as BLEFT JOIN F_CUSTOMER_ALT_CUST_ID C ON LEFT(B.[Column 0],CHARINDEX('.',B.[Column 0])-1) COLLATE Latin1_General_100_BIN2 =C.LEGACY_IDWHERE REPLACE(B.[Column 0] COLLATE Latin1_General_100_BIN2 ,LEFT(B.[Column 0],CHARINDEX('.',B.[Column 0])-1),isnull(C.T24_ID,LEFT(B.[Column 0],CHARINDEX('.',B.[Column 0])-1))) COLLATE Latin1_General_100_BIN2 in(SELECT LEFT(REPLACE(HIST.RECID,LEFT(HIST.RECID,CHARINDEX('.',HIST.RECID)-1),isnull(D.T24_ID,LEFT(HIST.RECID,CHARINDEX('.',HIST.RECID)-1))),19) FROM t24testsby.dbo.FBNK_LIMIT#HIS AS HIST WITH(NOLOCK) LEFT JOIN F_CUSTOMER_ALT_CUST_ID D ON LEFT(HIST.RECID,CHARINDEX('.',HIST.RECID)-1)=D.LEGACY_IDWHERE LEFT(REPLACE(HIST.RECID,LEFT(HIST.RECID,CHARINDEX('.',HIST.RECID)-1),isnull(D.T24_ID,LEFT(HIST.RECID,CHARINDEX('.',HIST.RECID)-1))),19) NOT IN(SELECT RECID FROM t24testsby.dbo.FBNK_LIMIT WITH (NOLOCK)))I've tried but i don't know why doesn't finish |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-03-27 : 04:52:59
|
what is the problem with above query? |
|
|
|
|
|
|
|