But this one doesn't return NULL, so a bit puzzling to me

SELECT CHOOSE((CAST(T.[Rand]* 10 AS INT))%3.00 + 1, 'one', 'two', 'three') Choice,
  ...

But this one doesn't return NULL, so a bit puzzling to me

SELECT CHOOSE((CAST(T.[Rand]* 10 AS INT))%3.00 + 1, 'one', 'two', 'three') Choice,
    ...

• This reply was modified 5 years, 11 months ago by ChrisM@Work.

Works for me. Thanks Steve.

The link is to a Tony Davis article about Data Compression. [ Now...

• This reply was modified 6 years, 2 months ago by administrator.
• This reply was modified 6 years, 2 months ago by administrator.

Your script contains two queries, do you know how much of the total execution time each one takes?

Can you provide an execution plan for each of them, as a .sqlplan...

So, I don't want to argue through all this. We had a number of things, not just management, that pushed a release. Quite a few of the items wouldn't...

@itsrainman you've coded this:

WHERE 
(i.[Despatch Date] IS NULL) 
AND (i.[Cal Date] IS NULL) 
AND (i.[Despatch to subcontractor] IS NOT NULL) 
AND (i.[Return from Subcontractor] IS NOT NULL)...

Hi Mike

One of our solutions here uses a snapshot of a replicated database to replace a backup/restore process which used to take hours (about 12 of them). We don't talk...

Have you looked into database snapshots for this? It would save you a heck of a lot of coding.

-- Work with what you can see.
-- Compare the columns from both sides, add to the matching columns list when you've figured out what's going on.
SELECT
T.[CustomerID],
T.[RelatedReferenceID],
T.[RelatedReferenceType],
T.[Due Date],
'#'...

I am going to develop a dashboard to monitor various stats about our Testing Environments. One piece of information I want to pull is the date that a refresh...

-- Use EOMONTH(H.startdate) instead of datename(MONTH,H.startdate), datepart(YEAR,H.startdate)
-- and remove h.Quantity from the GROUP BY
SELECT
RTRIM(COALESCE (E.PreferredName, E.FirstNames)) + ' ' + E.LastName AS [Name],
sum(H.Quantity) as [Hours],
datename(MONTH,x.YearMonth) as [month],
datepart(YEAR,x.YearMonth)...

• This reply was modified 6 years, 3 months ago by ChrisM@Work.

How nice it is to see this again - a bunch of folks working the hell out of a problem to come up with their solutions, each one faster and...

This looks about right, and if it is, then the start and end dates can be calculated.

;WITH SampleDates AS (
SELECT * FROM (VALUES 
(GETDATE()+0),
('2019-01-26'),
('2019-01-27'),
('2019-01-28'),
('2019-01-29'),
('2019-01-30'),
('2019-01-31'),
('2019-02-01'),
('2019-02-23'),
('2019-02-24'),
('2019-02-25'),
('2019-02-26'),
('2019-03-23'),
('2019-03-24'),
('2019-03-25')
) d (thedate)
)

SELECT 
thedate,
z.RealStartDate,
RealEndDate...

If you can batch up those inserts so that they are taking place under your control every 24 hours rather than at random every few minutes or so, your whole...