If you dont want to use the case in where condition you can consider using Common Table Expression and then use your new columns in where condition in another select...

For my sample data, the result look like this:

CardIdTransDatePositiveNegativeBalance

11/1/2000914.36-745.95168.41

11/2/2000706.22-1030.15-323.93

11/3/2000699.53-1039.36-339.83

11/4/2000811.9-381.81430.09

11/5/2000888.44-891.95-3.51

11/6/2000539.8-556.76-16.96

11/7/2000600.8-527.1973.61

11/8/2000576.08-747.02-170.94

11/9/2000309.6-673.64-364.04

Just to add one more thing.

After the merge of the two table, Remember to update the column Flag wint P if the value is Positive and with N if the...

Find here my contribution:

Consider creating a temporary with the same structure as you two table table like this ( Just add a column Flag char(1)):

CREATE TABLE [dbo].[myPoints](

[CardId] [int] NULL,

[TransDate] [date]...

Thanks Guys,

I have fixed the issue.

I am using now the Unrestricted permission set and changed the scope of my web references to Application instead of User.

Thanks alot for your support

The utilities class in inside the webservice. i have referenced directly as your screen shot show.

If I call the method in a windows form app works fine.

I have created the...

Actually i am calling a web service method that i am referenced using the settings:

Name:EngClearing_UtilitiesReference_utilitiesclass

Type:http://10.121.194.166/SysproWebServices/utilities.asmx

Value: Web Service URL

On .net works fine by when i create assembly In SQL...

Actually I am referencing a web service with the settings:

Name:EngClearing_UtilitiesReference_utilitiesclass

Type:Web Service URL

Value: http://10.121.194.166/SysproWebServices/utilities.asmx

In .net work fine by when i create assembly in sql server 2008 gave me...

Actualy the class utilitiesclass belongs to a web service that i am referencing on my class library.

I have tested the call locally and it is working, but in sql server...

Now I am getting only the messages:

The settings property 'EngClearing_UtilitiesReference_utilitiesclass' was not found.

I have used SAFE

Now I have got this code in C#.net in my Class library:

[SqlProcedure]

public static void doCostChange(string username, string password,...

Hi Stewart, you are rigth. It is an example only.

Thank you!

Thank you so much.

Regards