Another great Article.

Thanks...

Try Count instead of SUM.

OR

Get the results seperately for each Union into another table

for example,

Insert into @t1

Select ...

and Get @@ROWCOUNT after each Insert.

I think this will be...

Are you asking for the Currently Logged In users in the SQL Server?

see master.dbo.sysprocesses.

If you are willing to store the history of the Logged In Users, Create SP and...

Code4Cash,

I dont know the details of XML in SQL Server 2000, but there is alot you can do in SQL Server 2005.

I think it all depends upon the indexes on your data. The frist choice, as per my opinion, should be LEFT OUTER JOIN for consistent performance.

By specifiying an execution context (such as by using the execute as user = 'user1') in which a module (such as a sp, trigger, queue etc) is executed, we can...

Plz check http://msdn.microsoft.com/en-us/library/ms191296.aspx.

The example in the link will explain all to you.

Its much better to set Default Values for such columns where NULLs can be inserted. This resolves many conversion issues.

How about storing data in XML Format and then XQuery the data on the maximum available elements...?

--XML For Client 1

Declare @vXML XML

Set @vXML = ''

Select x.header.value('@ClientID','int') ClientID,

x.header.value('@C1','nvarchar(50)')...

It might be also like this (with the Insertion into another table Part...)

Declare @tbl Table (id int, idv varchar(10))

Insert into @tbl

Select 1,'1' Union All

Select 1,'2' Union All

Select 3,'3' Union All

Select...

Select ContactId from Contacts

EXCEPT

Select ContactId from Incidents

Check this out...

http://www.sqlservercentral.com/articles/Administration/exploringdeadlocks/616/

In such case when Source have different datatypes as compare to the destination, there are alot of comparisons to be made to avoid the conversion errors.

You will have to...

If you are diciding that the XML is cutting short with the help of PRINT statement, let me tell you that the print statement prints the limited number of characters.

I think The condition should do it.

where

(delivery_date between @StartDate and @EndDate)

And

(

(driver = e.emp_cd and (driver = @Driver or '%' = @Driver))

or

(helper = e.emp_cd and (helper =...