Googling Hyderabad it looks like it is in India:

On the csv source in you DTS package, be sure you have the Text Qualifier set to Double Quote ".  It sounds like it may be set to none.

hth

Full backups do not truncate the transaction logs, only transaction log backups do that.  During a full backup, only enough of the transaction log is backed up to ensure a...

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' )