Recent content by TRACEYMARYLAND

I just did this CHARINDEX(',' + CAST(VMFG.DBO.PART.PRODUCT_CODE as varchar(100)) + ',',',' + case @str1 when '' then CAST(VMFG.DBO.PART.PRODUCT_CODE as varchar(100)) else @str1 end + ',')>0 That seems to work

Where would that code go before the select ? Thanks

hi i have declare @str nvarchar(50), @str1 nvarchar(50), @str2 nvarchar(50), @str3 nvarchar(50) set @str1 = 'CHEMBIO' set @str2 = 'DECON' SELECT ORDERNUM, DESCR, VMFG.DBO.CUST_ORDER_LINE.PART_ID,LINE_NO,VMFG.DBO.PART.PRODUCT_CODE,* FROM PRODSCHED INNER JOIN VMFG.DBO.CUSTOMER_ORDER ON...

Ok let me research ....the keywords cheers

I have a description field that consists of (1)SD3-UZA08-GZ(2)LF-40-1(8)FR-24-48(4)HS-X-P(1)WP-18-S(2) (1)SFR-UZA08-ZK (1)SCM-WaA09-ZG(2)DG-5.5(4)LF-40-1(1)AH-125-15(1)WP-18-S(1)WH-340-1-1 (2)SD1-TTB02-GZ (1)SD3-UZA08-GZ(2)LC-1810-X(1)LCA-B(4)HS-X-P(8)FR-24-48 (1)SCM-WaA10-ZG...

i could never get the UNC link to work either, how did u do the map part....

oh i forget the name its...dllhost.exe

run iis5recyle its a tool that will clear out yr server deadlocks. try this first... go to applications tasks alt tab and delete dll.host

Thanks i got it

Thanks i get a bit worried with deletes ..... Cheers

Like so DELETE DATAWAREHOUSETEST.DBO.SHELTERPRODUCTS FROM DATAWAREHOUSETEST.DBO.SHELTERPRODUCTS INNER JOIN VMFG.DBO.WORK_ORDER ON DATAWAREHOUSETEST.DBO.SHELTERPRODUCTS.WORKORDER_BASE_ID=VMFG.DBO.WORK_ORDER.BASE_ID WHERE VMFG.DBO.WORK_ORDER.STATUS NOT IN ('F','R') So before i run it...

hi my select works but when change select to delete from it errors on inner join SELECT * FROM DATAWAREHOUSETEST.DBO.SHELTERPRODUCTS INNER JOIN VMFG.DBO.WORK_ORDER ON DATAWAREHOUSETEST.DBO.SHELTERPRODUCTS.WORKORDER_BASE_ID = VMFG.DBO.WORK_ORDER.BASE_ID WHERE VMFG.DBO.WORK_ORDER.STATUS IN...

It has to be registered on the Server. What you can try is to register just the email dll cdonts and see if that at least works..... I not so sure about C# but i know VB it has to be active X dll.... Thats all i can offer

hi i have textarea and i allow user to type in so for example i have line1 line2 line3 line4 In database i see just line1 when i do delete after the line 1 i see line2 comes in....so it must have a carriage return in the data. So now i did to display it What i want to do is just display in...

Can you remove the ' first before importing the data.. and then to put in the data use the replace function Replace(strName, "'", "''")