Viewing 15 posts - 2,821 through 2,835 (of 5,111 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...
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...
October 16, 2017 at 12:16 pm
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...
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:'...
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...
October 16, 2017 at 11:05 am
Okay, so for time do this:
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?
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...
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.
October 16, 2017 at 10:25 am
Can you see any of the files that were previously on Windows 10 in your My Documents?
October 16, 2017 at 10:13 am
When I execute the query (first one) I get below errror:
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).
October 16, 2017 at 9:13 am
October 16, 2017 at 9:06 am
Viewing 15 posts - 2,821 through 2,835 (of 5,111 total)