Select Max(C10) MaxC1, Max(C11) MaxC2

from

( select C10 , C11 from T1

  UNION ALL

  select C20, C21 From T2

) Q

to overcome the LEN issue you could use DATALENGHT instead

>>>Hand up, everyone who in detail can explain exactly what DATEADD(d,DATEDIFF(d,1,getdate()),0) does, and why it works the way it does. <<<

That, is a VERY WELL KNOWN TRICK in...

BTW Noel, could you be more specific about 'qualify your fields?'

When I mentioned Qualify the fields I meant to put the ALIAS or Tablename before it like

Select a.Fld1, a.Fld2... from...

the timestamp column CHANGES if you update any other column in the row!

HTH

Edwin,

 You will find here what you are looking for

HTH

You have several issues in that code:

ex: you have to perform the read of all the interested variables in one shot like: select @rcnt = @@rowcount. @err = @@error and...

have a look at this thread. There is a DMO solution to detect if the connectivity to the server is good

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=152697#bm152737

Jonathon,

If you have to update the Whole Table (No where Clause) there is very little you can do. If you write a single update a table scan is going to...

You can move DATA and Indexes but not other objects like sp or views.

To move a table that has a clustered index on it simple Recreate the index using the...

OK I am going to tell you a little secret   use it at your own risk

if...

Declare @str varchar(40)

Set @str = '0011111111111111'

create function dbo.udf_FromBitmToInt( @Str varchar(64))

returns bigint

as

begin

 declare @cntr int, @result bigint, @len int

 -- init vars

 Select @len = len(@str), @cntr = len(@str), @result =0

 While @cntr > 0

 begin

 if...

>>You can turn off logging by changing the database recovery model to 'simple', using ALTER DATABASE command.<<

That is not true, you can't turn logging off on SQL Server. The...

1.find out what RECOVERY MODEL is the database in?

To know that Run on QA the following replacing the letters in italics by the actual database name:

select databasepropertyex('YOURDATABASENAME','Recovery')

2. if it is...

1.Any Full Backups ?

2.What Recovery mode is the DB in?