Prema,

That would work if he wanted 1.7325 to display as 1.7325 as 1.7325.  He wanted 1.7325 to display as 1.732 not as 1.733.  Using the round function - round(unitsellprice, 3,...

Actually rather simple, try this:

round(@value, 3, 1)

happy hunting!

Add the column name to the INSERT:

DECLARE @OrdDate datetime

DECLARE @tbl TABLE (ID INT IDENTITY(1,1), CompanyName varchar(40) )

INSERT INTO @tbl (CompanyName)

SELECT DISTINCT CompanyName

FROM NorthWind..Customers c

INNER JOIN NorthWind..Orders o ON o.CustomerID =...

I'll agree that IN could result in a performance issue, especially if you have a very large list.  However, with a short list, as in this case only two values,...

That solution looks good, but why don't you like it?

Vladen,

I realized that as soon as I had posted it.  Hopefully, and only testing in a mobile environment (which I don't have), the second option will work.  Looks cleaner than...

Sorry, missed something in my testing, this is what you should try:

dateadd(d,datediff(d,0,

Trystan,

Try this for your where clause:

dateadd

(d,datediff(d,0,CreatedDate),0)

try this:

select DATABASEPROPERTYEX( 'yourDBName' , 'Recovery' )

If you have hardcoded the dates, just change in the set statement.  I guess it depends on how and where the dates are coming from for you queries.  If it...

True, you can't backup the physical .mdf/.ndf/.ldf files if the database is open.  If you read between the lines, however, you can see that the question was actually about backing...

It is the format of the dates in @DocDateFrom and @DocDateTo.  These are in the US format.  When you change to UK, the date format changes from mm/dd/yyyy to dd/mm/yyyy. ...

Using the native SQL backup you can backup and restore individual files/filegroups.  Again, please read BOL.  It does have the information you need to get started.  Our databases are not...

The native SQL Backup can be run while the database is in use.  Most third party backup software can also backup SQL databases while they are online as well.  Take...

You should also be aware that Full and Differential backups do not truncate the log file if your database is in bulk-logged or full recovery mode.  If this is the...