ive came across this... http://forums.silverlight.net/forums/p/181776/439246.aspx

Silverlight 4

I would love an example of how to do it in clr, i have no idea!

i dont know if a clr can consume a web service url like a web...

im also trying with a ERPConnect35 version running same sql statements for VS2008 and i get this...

Assembly 'ERPConnect35' references assembly 'system.windows.forms, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089.', which is not present in the...

in fact to sign that it is for the clr, this if for a third party dll i need to reference

no i didnt sign it, is that in the signing tab? and if so what strong name key file will i give it?

I've set the db to trustworthy and set...

OK so when i put this on sql server path should that dll assembly be available then for reference?

and do i then need to run same sql for the CLR?...

Ive ran this first

USE [WT]

alter database [WT] set trustworthy on

EXEC sp_configure 'show advanced options' , '1'

go

reconfigure

go

EXEC sp_configure 'clr enabled' , '1'

go

reconfigure

go

the when i run this...

USE [WT]

CREATE...

OK thank you.

Is it also possible to add a delete from table first then do insert and select?

DELETE from wp4tbl_TblCompVerifySapBatch where EXISTS

(SELECT TB.name.column, TB.name.column, TB.name.column, TB.name.column, TB.name.column

FROM [10.146.22.35].smartreports.tablename AS TB

WHERE TB.name.column =...

OK, so you think this possible...

CREATE PROCEDURE [dbo].[w4sp_getSAPData]

@Workorder nvarchar(12)

AS

SET NOCOUNT ON

GO

begin

INSERT INTO wp4tbl_TblCompVerifySapBatch (Workorder,Docyear,movementtype,BatchNumber,Qty,MaterialNumber)

...

Hi

The select query for the LS i need to get that correct that was just a quick example of what im trying to achieve.

hope below makes sense.

and this is my...

Hi crazy4sql Im not the best with sql could you show me an example of what you mean?

I 'll be able to do the select part that will be fine,...

Anyone any ideas?