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...

Do you remember which proc failed??

This could be a very simple fix but I just didn't think about it :

try adding another return somewhere in the proc.

(Long story short,...

I don't think they would compile if the table name is correct. But I can't test from here, maybe tomorrow.

I'm still a first year programmer... I'm just real good in tsql, I'm not a god. yet .