Viewing 15 posts - 2,311 through 2,325 (of 3,221 total)
BitBucket and Lynn,
I'll throw my hat in the ring in your favor. I can't argue as eloquently as Lynn, but I'll say this - you are absolutely correct. I'm in...
November 17, 2009 at 9:31 am
Cliff Jones
My users would expect to see CST and GMT appended to the result
What you are discussing has been addressed by Lynn Pettis, you are referencing the mode...
November 17, 2009 at 8:09 am
Lynn Pettis has explained in great detail the reason the times are the same, and as a matter of fact has explained the reasoning better than I could have. ...
November 17, 2009 at 7:59 am
OK but give us a little additional information... what table(s) contain the information you need? How are the tables linked (Foreign key) or?
What have you attempted (your T-SQL...
November 16, 2009 at 5:51 pm
You might want to look at the date part function in Books On Line:
DATEPART (Transact-SQL)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/15f1a5bc-4c0c-4c48-848d-8ec03473e6c1.htm
November 16, 2009 at 3:56 pm
This will give you an approximate answer:
declare @thisTime decimal(8,2)
declare @thisTime2 decimal(8,2)
set @thisTime = datediff(ss, getdate(), '11/22/2009')
set @thisTime2 = CAST(datediff(ss, getdate(), '11/22/2009')AS DECIMAL(8,2))/3600
select @thisTime AS 'Total seconds' ,@thisTime2 AS 'Total...
November 16, 2009 at 1:54 pm
Trooper09 - Do you believe that the index fragmentation is effecting your performance? Which method of rebuild/defragging did you use?
From the same link that you posted: (Emphasis added)
http://msdn.microsoft.com/en-us/library/ms188917.aspx
Reducing Fragmentation...
November 12, 2009 at 1:43 pm
I think that SSRS is NOT exporting data to EXCEL 2007.
From my Excel 2007 help file:
WorkSheet size 1,048,576 rows, 16,384 Columns.
Other improvements to Excel:
http://visio.mvps.org/Excel_2007.htm
If memory serves me correctly...
November 11, 2009 at 3:46 pm
render to Excel 2007 for our execs but every time I try to export it if fails
Specifically what error message is returned?
November 11, 2009 at 1:30 pm
Suggest you read the articles on indexing written by Gail Shaw the 2nd of which is the featured article today
http://www.sqlservercentral.com/articles/Indexing/68563/
You also might want to spend time looking at these videos...
November 11, 2009 at 1:10 pm
Modify the following:
;with numbered as(SELECT rowno=row_number() over
(partition by your duplicate column, order by Your duplicate column),col1, col2, col3 from your table name)
select * from numbered WHERE...
November 11, 2009 at 10:20 am
Greg Albrecht-252263
Greg it would help those who want to help you if you would provide further information. Is your date a DATETIME value, or is it month/day/year in...
November 10, 2009 at 4:41 pm
alpeshgediya
A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL...
November 10, 2009 at 4:01 pm
Use the code posted by george sibbald-364359 to this forum.
November 10, 2009 at 3:38 pm
Rather impatient aren't you... that said try this (Contributed by one unknown to me, prior to your asking the question. To this individual we both owe a hearty THANK...
November 10, 2009 at 2:54 pm
Viewing 15 posts - 2,311 through 2,325 (of 3,221 total)