Viewing 15 posts - 5,341 through 5,355 (of 13,877 total)
July 31, 2017 at 10:26 am
This should get you startedSELECT TicketId
,NAME = max(NAME)
,DateReceived = min([DateTime])
,DateClosed = max([DateTime])
FROM TABLE
Group BY TicketId
Note that 'DateTime' is a datatype...
July 31, 2017 at 9:08 am
July 31, 2017 at 7:46 am
You have written a very clear and concise article to demonstrate how you have put things together and I congratulate you for that. Sounds like you have a solution which...
July 31, 2017 at 6:39 am
When I compile and deploy the project to SQL Server 2012 (SSIS version 6)...
July 30, 2017 at 7:36 am
July 28, 2017 at 2:03 pm
July 28, 2017 at 1:45 pm
The DTA is not kindly looked upon in these forums. It tends to produce quirky recommendations.
There are far better ways of tuning indexes, if you are interested...
July 28, 2017 at 1:43 pm
I have cubes where their folders are built from facts and dimension tables, and in...
July 28, 2017 at 8:13 am
If you run the same query from, say, Access, (using the same driver) is there still an attempt to create the VIEWs?
July 28, 2017 at 6:03 am
We’ve got a weird thing happening and I wanted to run it past you...
July 27, 2017 at 2:31 pm
July 27, 2017 at 9:30 am
July 27, 2017 at 6:43 am
ThomasRushton - Thursday, July 27, 2017 5:17 AMUpdate the metadata in the binaries...? My head hurts.
..from laughing so much.
July 27, 2017 at 6:39 am
Presumably you can write the query to get 'date last invoice loaded'.
Here is a query to get 'last billing date':SELECT
LastBillingDate = IIF(DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 24)...
July 26, 2017 at 1:47 pm
Viewing 15 posts - 5,341 through 5,355 (of 13,877 total)