Take the quotes off the variable:

s.vcDisplaySchoolName = @vcDisplaySchoolName

You might try something like below:

DECLARE @StaffCodeErr tinyint,

@ContactErr tinyint,

@AlternateErr tinyint,

@Name varchar(400)

set @Name = ' '

/* Check the StaffCode column in the Providers table */

SELECT@StaffCodeErr = COUNT(*)

FROMProviders, inserted

WHEREProviders.ProviderNumber = inserted.ProviderNumber AND...

Potential world enders:

Godzilla or any of his friends except Mothra

Population explosion

Nuclear winter

Zombies

The Andromeda strain (or Captain Tripps, the T-virus or any of a number of mutated viruses)

Any large space rock

Agressive...

I think this construct:

IF (SELECT inserted.StaffCode

FROM inserted

WHERE inserted.StaffCode NOT IN

(SELECT inserted.StaffCode

FROMinserted, deleted

WHEREinserted.StaffCode = deleted.StaffCode)) > 0...

Is there a trigger on the table? I'd guess that the trigger can't handle the multiple rows being updated, and it's the trigger that's giving you the message. The...

I always learn something new every time I try one of these.

Thanks for jumping in, Lynn.

Had a syntax error on the select, but this runs:

SELECT E.P_Service, tasks...

This puts it all together with the like breaks (char(10)), but going through XML changes them to

Hmmmm... have to think on this a little more.

create table #txt1 (

P_Key int...

How do you know what order to concatenate the texts? Or does it matter?

Maybe this will help:

http://www.mytechmantra.com/LearnSQLServer/Troubleshoot_OLE_DB_Provider_Error_P1.html

I'd script them all out from SSMS (in object explorer details mode) and move them that way. Not pretty, but fairly straightforward since you can get them all at...

Are your backups going to a different drive than the one that's running out of space? Probably a silly question, but just wanted to make sure it wasn't your...

You can do something like:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

drop proc [dbo].[Make_table]

GO

create proc [dbo].[Make_table] @tablename varchar(512)

as

declare @statement varchar(7500)

declare @table_name varchar(512)

set @table_name = @tablename

set @statement = ' (column1 varchar(25) not null,...

I have to echo Sean's comments. If you are storing date or date and time, you should really use the data types created for those sorts of values. ...

I think it's the 'select's inside the functions. You don't need them.

Does this do it:

update messages

set message_date = cast((datediff (year, (select DATEADD(year, 1, CONVERT(datetime,(dateadd(second, message_date /1000 + 8*60*60, '19700101')),...

Yes, that would make sense, but if it's really the same concatenation, then I gotta wonder....