Viewing 15 posts - 26,341 through 26,355 (of 26,490 total)
Googling Hyderabad it looks like it is in India:
| Hyderabad, the fifth largest metropolis of India, is the state capital of Andhra Pradesh, known for its... |
November 2, 2006 at 10:42 am
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
November 2, 2006 at 6:53 am
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...
October 31, 2006 at 11:12 am
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).
October 31, 2006 at 9:44 am
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'
![]()
October 31, 2006 at 9:31 am
Your create statement should look like this:
create procedure dbo.ProcName
![]()
October 31, 2006 at 8:50 am
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,...
October 25, 2006 at 4:19 pm
Actually rather simple, try this:
round(@value, 3, 1)
happy hunting!
![]()
October 25, 2006 at 1:30 pm
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 =...
October 24, 2006 at 9:38 am
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,...
October 17, 2006 at 9:17 am
That solution looks good, but why don't you like it?
October 17, 2006 at 8:55 am
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...
October 17, 2006 at 8:47 am
Sorry, missed something in my testing, this is what you should try:
dateadd(d,datediff(d,0,
October 17, 2006 at 8:43 am
Trystan,
Try this for your where clause:
dateadd
(d,datediff(d,0,CreatedDate),0)
October 17, 2006 at 8:35 am
try this:
select DATABASEPROPERTYEX( 'yourDBName' , 'Recovery' )
![]()
October 12, 2006 at 3:14 pm
Viewing 15 posts - 26,341 through 26,355 (of 26,490 total)