From what I can see, it would appear that you are attempting to stuff:

@Tab1description varchar(2000)

and

@Tab2Description varchar(2000)

into

@body varchar(2000)

Thats probably why you are getting the 'string would truncate' error and why it...

From a performance perspective, you will probably find that a CLR Procedure/Function might out perform a TSql Solution when it comes to heavy duty String manipulation. You also have...

Actually, you could probably dispense with the loop and the temp. table by outputting the CpuIds as xml to an xml variable, passing it as a parameter to sp_updateUsers and...

Glad I could help.

Typically, you will need to identify the Primary/Unique and Foreign Key columns of the Tables you wish to join.

You can look it up in the Entity Relationship Diagram(if you have...

try this:

declare @a int, @b-2 int

set @a = 7

set @b-2 = 3

if((@a%@b)=0)

print 'is a whole number'

else

print 'is not a whole number'

Assuming you are calling the Stored Procedure from within a try..catch block in your application (C#, VB) and the Procedure returns an error, you can catch the SqlException and simply...

I wondered if there was any specific reason for wrapping your 'send mail' function in an agent job? I would have thought you could have used the likes of database...

Regardless of how you code it, I think you will find that the Return keyword should exit a Trigger / Procedure unconditionally.

ah right. Thanks for clearing that up, Lutz.

Chim Kalunta

This is probably more a question than it is an answer but, if the data is stored in an xml data type what stops you from just using any one...

Well, there are a couple of ways you can do this. Here is one of them:

IF OBJECT_ID('your_table_name') IS NOT NULL

-- Then do your stuff!

Hope that helps.

Chim Kalunta

I'm not sure I understand your question. Do you want to write some TSql that will check for the existence of a table that you can then plug into...

I whipped this up on a Sql 2008 instance. I'm not sure if it will work on 2005.

CREATE TABLE #ConcatValues

(

value VARCHAR(10)

);

GO

INSERT #ConcatValues

SELECT 'aaa'

UNION ALL

SELECT 'ccc'

UNION ALL

SELECT 'bbb'

UNION ALL

SELECT 'ddd'

GO

DECLARE...

I'm not sure what version of Sql Server you are using but take a look at this:

http://support.microsoft.com/kb/937277

Chim Kalunta