Easiest way to change the owner.  I couldn't remember the syntax for the sp_chengeobjectowner sproc even though I have used it on several occasions (that's what BOL is for though).

try this:

UPDATE fmlog SET

    fm_rk_trn_dte = dateadd(mm, -1, fm_rk_trn_dte)

WHERE

    MONTH(fm_rk_trn_dte) = 9

    AND fm_rk_trn_dte BETWEEN '2006-09-06' AND '2006-09-15'

Your create statement should look like this:

create procedure dbo.ProcName

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. ...