Nice and clear question - thanks Ron

If you only want the results for the user have you tried something along the lines of this:-

USE [master]

GO

/****** Object: StoredProcedure [dbo].[usp_who] Script Date: 03/14/2013 14:57:25 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

If you could supply table structure, the queries you have written so far along with sample data - see the first link in my signature for the best way to...

Bad post - sorry

Nice and easy question to end the week on - thanks

OK - Don't have a column with it in on your report.

instead maybe have a textbox at the top with a value of

=first(fields!Supplier)

to remove the supplier from the...

(Potentially) daft question - have you run the same query in SSMS to see if you get the duplicates there?

One answer is

SELECT DISTINCT

id ,

mark

FROM

...

Thanks for that but the bit I'm looking for is :-

Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

There is a version of SQL server (express) that...

Run

SELECT @@VERSION

That should give you a whole load of info about your server. Best bet to see all the information is to run it to text (ctrl + t)...

With most of the people here - just because you haven't seen it doesn't mean it can't / won't happen to you.

I wonder if they would take the same approach...

What version of SQL are you using? Developer, Enterprise, Express etc?

Hi - it might be worth checking what other software you have installed on your Dev server - is the hardware the same spec and so on. Otherwise you won't...

(to) infinity

Nice and easy start to the day - thanks