Viewing 15 posts - 1,321 through 1,335 (of 2,007 total)
rcr69er (11/21/2011)
There already is written documentation 😀
I more meant something absolving you of responsibility, preferably signed by the DBA that enforced the NOLOCK, his manager and your manager.
November 21, 2011 at 3:35 am
rcr69er (11/21/2011)
HiI agree with you about the NOLOCK statement. But its the standards set by the DBAs to use on the report server. so I have to follow them!
I'd...
November 21, 2011 at 2:49 am
anthony.green (11/18/2011)
November 18, 2011 at 9:41 am
Sorry, but without DDL and sample data your query doesn't really mean anything.
However, while I'm looking at it. . . you know that NOLOCK is not the magic go faster...
November 18, 2011 at 9:21 am
Welsh Corgi (11/18/2011)
Lowell (11/18/2011)
so you want the Sunday that occurred before *today*, that would be the same code, but minus one isntead of minus 8, sorry i misunderstood the question.
It...
November 18, 2011 at 8:48 am
Any non-numerical data in either of them?
November 18, 2011 at 8:41 am
rcr69er (11/18/2011)
Sorry my mistake, guess it was a typo.The statement should have been =SUM(Fields!ThisWeekLatestViewSales.Value)/Fields!TaxRate.Value
Have you tried converting both to CDec?
November 18, 2011 at 8:13 am
Welsh Corgi (11/18/2011)
Cadavre (11/18/2011)
Welsh Corgi (11/18/2011)
I need to Calculate First Day of Previous Week.
Today the 1st Day of last Week is Sunday 2011-11-13.
I do not want the time...
November 18, 2011 at 8:06 am
rcr69er (11/18/2011)
HiBrackets seem fine as I only need an overall sum of the first field.
Thanks
How are the brackets fine?
=SUM ( Fields!ThisWeekLatestViewSales.Value ) /Fields!TaxRate.Value )
There's no opening bracket to match...
November 18, 2011 at 7:45 am
UnicornsRreal (11/18/2011)
I keep missing the simple things... sorry and thanks for your help
So long as you show that you've tried, no-one minds helping out 😉
November 18, 2011 at 7:38 am
If you're explicitly setting the "USE" value, then you don't need to query sys.databases anyway.
Try: -
EXEC ('USE [REMOTE_TEST]
SELECT DISTINCT QUOTENAME(sm.[Name]) + ''.'' + QUOTENAME(OBJECT_NAME(s.[object_id]))
AS [Table] FROM sys.dm_db_index_physical_stats (DB_ID(),...
November 18, 2011 at 7:30 am
Welsh Corgi (11/18/2011)
I need to Calculate First Day of Previous Week.
Today the 1st Day of last Week is Sunday 2011-11-13.
I do not want the time part of the...
November 18, 2011 at 7:21 am
Tom Brown (11/18/2011)
http://www.sqlservercentral.com/Forums/Topic1208130-391-1.aspx
He's then attempting to break down the problem in this
http://www.sqlservercentral.com/Forums/Topic1208227-391-1.aspx
Its not clear exactly whats wanted on first reading, but I...
November 18, 2011 at 6:20 am
Hardly surprising. $100,000 ~ £60,000 - with that I could pay off mine and my girlfriend's student debt (£30,000 for me, £18,000 for her) and be able to put...
November 18, 2011 at 6:11 am
Viewing 15 posts - 1,321 through 1,335 (of 2,007 total)