Viewing 15 posts - 2,821 through 2,835 (of 5,109 total)
SSRS is accessed via the web portal. You'll need to ensure you also open port 80, so that deployment can occur between the 2 and so that other users can...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 1:52 pm
Are you planning to upgrade to the server that SSRS is on, or the data engine, or both? If the latter, remember that each server requires separate licences. You seemed...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 12:16 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 12:08 pm
The dashes are as wide as the column is. When returning results in SSMS using the Text format, it returns the data in Fixed Width format. Thus, if you have...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 11:49 am
The reason for the LTRIM is because of the extra space that might be returned when the hours is below 10. For example, without LTRIM the value might be:'...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 11:34 am
Lynn Pettis - Monday, October 16, 2017 11:02 AMEverything I have heard about FORMAT, I try to stay away from it.
When...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 11:05 am
Okay, so for time do this:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 10:58 am
Give this a go:LTRIM(RIGHT(CONVERT(varchar(20),[ie].[DateTime],100),7))
That'll give you a AM/PM. Do you also need the space?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 10:56 am
I'm not happy to download a stranger's Excel document I'm afraid (you'll find few who are). Sorry.
I covered doing separate counts, however, in my original answer:
If you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 10:35 am
More than likely it's the FORMAT. Instead of this:FORMAT(Invoice_Exceptions.DateTime, 'MM-dd-yyyy')
Try:REPLACE(CONVERT(varchar(10), Invoice_Exceptions.DateTime,101),'/','-')
Hopefully that'll speed things up for you. 🙂
Edit: Typoed Formatting number.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 10:25 am
Can you see any of the files that were previously on Windows 10 in your My Documents?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 10:13 am
When I execute the query (first one) I get below errror:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 9:16 am
Blargh. I hate queries like this. Personally, I don't think SQL Server is the right choice for this type of syntax (and i imagine many others here will agree). Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 9:13 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 9:06 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2017 at 9:02 am
Viewing 15 posts - 2,821 through 2,835 (of 5,109 total)