The problem is that I dont have a way if changing the source code. this is an old ERP system (PSI) that its was based on SQL server 7. now...

Albania, I dont know if you heard about that..

This Payroll System will not be apply to USA System. This will be in Europe. That's why we need a Unique System since the most of Software system are based...

Our Boss wants something unique not one off the Shelf. Plus the Application will be simple just keeping monthly payroll and reports

thank you all I found the right Solution. Here is if someone is interested:

SELECT case when Max(Id)+1 is NULL then IDENT_CURRENT ('tblJobs') else Max(Id)+1 end from tblJobs

this one solves...

There would be a problem with my first Item. It will not return 1 it will return null......

HI, Im using something like that But Im handling in the Code:

protected void EditStaffRoles()

{

try

...

Thanks Jason ,

I got it working by using RowNumber = ROW_NUMBER() OVER(Order BY ProductName)

Thanks everyone for all your help

For somehow it doesnt work on my database. Actually i display the klient code Also( The code of the person that Sell this products) When I have more than One...

HI Jason

thanks for the Query but I still dont get the Expected results. It repeats the same product name for the same client three times?????

Seems like the ProductName soesnt...

here is a sample of the Query . From the query below Im getting only the Totals Order Amount in Dollars for each Product quarterly.

I want to display also...

Hi have you ever try to use varchar instead of datetime parameter??

In UK system is better like that:

declare @start_date as varchar(10)

set @start_date = convert(varchar, '24/07/2007', 103)

...

HI, I think its best for yu to create the database for each one so you have control and Assign a single user to single database. That way the...

see attached

that did the Trick

Thanks a lot