Andy,

my apologies for quoting your name in my post.

It seems that you have posted a second before I clicked Post reply so I read your name instead of Jerome's

Andy,

you missed aliasing the distinct select.

Try this:

SELECT COUNT(*) FROM (SELECT DISTINCT marq FROM vehicule) as a

Darko

On the client site check programs that are triing to logon to your SQL server.

I had similar programs long tima ago, when password for 'sa' user was changed and SQL...

Hi,

I'm not sure, what are your demands, but there are some thinks you can do to.

1. Check the Where conditions and indexes in table B (source table).

2. DROP all indexes...

Hi,

problem is that T-SQL does not allow assigning value to image, text or ntext variable.

If you wish to return value from ntext column from a table, use SELECT statement. You...

In SQL, if you want to specify unigode string you must use N'' style.

in your case

if ( @param1 = N'PING')

BEGIN

...

Darko