select x= 000031761*0.1

Results:

x

---------

3176.1

Use BACKUP and RESTORE. You can refer to SQL Server 2005 Books Online for detailed information on how to do this, starting with the link below.

SQL Server 2005 Books...

select

NewDate = dateadd(hour,a.TM/100,dateadd(minute,a.TM%100,a.DT))

from

( -- Test Data

select DT = convert(datetime,'2006-08-21'), TM = 1123

) a

Results:

NewDate

-------------------------

2006-08-21 11:23:00.000

(1 row(s) affected)

delete from MyTable

where

--- All Other Selection Criteria ---

and MyTable.ForeignKeyColumn not in

( Select MyOtherTable.PrimaryKeyCol from MyOtherTable )

You're #1 :exclamationmark:

DECLARE @Ctr table( Counter int NOT NULL)

UPDATE CONTROLTBL

SET

Counter = Counter +1

OUTPUT

INSERTED.Counter

INTO

@Ctr

--...

select

[HHHHH:MM:SS] =

right('00000'+convert(varchar(20),Seconds/3600),5)+

right(convert(varchar(20),dateadd(ss,Seconds%3600,0),108),6)

from

(

...

A foreign key by itself does not create an index, so it is a good practice to create a matching index on all foreign keys.

Instead of doing a SELECT and then an UPDATE, do an UPDATE with an OUTPUT clause so that everything happens in one statement.

Robert.Smith-1001156 (10/6/2009)

---

I'm reminded (and I'm dating myself here) of comedian Lily Tomlin's character Geraldine the Telephone Operator and her famous line "We're the Phone Company, sir. We don't have...

Function F_AGE_IN_YEARS in the script in the link below calculates age in years from @START_DATE through @END_DATE and returns the age as an integer.

Age Function F_AGE_IN_YEARS

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74462

There problem is that a month is not a set amount of time, so you have to define exactly what a half month and full month are?

If you are born...

IceDread (10/5/2009)

While I'd argue that there are lots of people that does not want mankind to go forward, like the Christian Church attempts to stop Scientists and control societies as...

That is exactly what I would expect in a hosting environment.

I have yet to encounter a hosting vendor that had any real knowledge about backup and recovery for SQL Server.

In terms of incidental DBA, I would define best practices in terms of what is least likely to let them shoot themselves in the foot and most likely to have...