I don't have nor know where to get that list, but I think that if you convert the cross join from a delete to a select, that you will get...

This query returns :

10JohnA

10John1A

20Mack

30Rock

40SilkB

40MannC

if I understand his requirements he wants this (without the __) :

10JohnA

__ John1__

20Mack

30Rock

__SilkB

40MannC

Totally agree with that Frank. Keep the server serving and the application applicating the presentation .

I' surprised nobody saw that mistake :

Replace (html, '<', ' ', '> ')

Maybe if you can answer this :

how do you invalidate 1 - 5 , 2 - 3 from

1 - 3 , 2 - 5, 1 - 5 ,...

Wow, so simple.......!!!!!!!!

Try updating less rows at the time. It'll take much less ressource to do this task.

if object_id('Test') > 0

DROP TABLE Test

GO

CREATE TABLE [Test] (

[id] [int] NOT NULL ,

[Name] [sysname]...

I think that this task would be much easier to handle at the client side. You could use group by on the report to remove some of the doubles,...

This is not the case for me. I didn't have #temp table or table variables in my trace.

God I hope he's done by that time (unless it's a 24H shop???).

Yup, looks like you're stuck with the cast anyways :

Declare @X as datetime

set @X = GetDate()

Select case when @X is null then 'some text' else @X end

--2005-06-08 08:11:26.967

set @X...

How long does it take to just run the select without transfering to access?

There's no easy way around this, basically what sql server is telling you is that the insert was rolled back because the primary is already in the table (the PK...

It would look something like this :

Delete from Table100 where exists (Select * from Table20 B where Table100.title = B.title and Table100.forename = B.forename And Table100.surname = B.surname and Table100.address1...

There's a little catch with the isnull function. It returns the same datatype and same lenght as the input value. This also means that each paramater must be...