Not sure how you figure the total for Jan, Feb, Mar 2022 is 11.  There are 4 in Jan, 5 in Feb, and 4 in Mar.  4+5=9 + 4 =...

I'm confused, my understanding is that the required result is the number of distinct customers in a...

The times are definitely stored in UTC. The right click method is clearly adjusting based on time zone, but I can't see any way to get the current time zone...

Never mind, you changed it.

How does this work with months of different lengths?

 where s.transactiondate > dateadd(month, -3, dt.t_dt)

If dt.t_dt is '2022-02-28' then dateadd(month, -3, dt.t_dt) is...

• This reply was modified 3 years, 2 months ago by Ed B.
• This reply was modified 3 years, 2 months ago by Ed B.

I imported the csv, so here's the data with a US formatted date added. I'm interested to see an elegant solution.

DROP TABLE IF EXISTS dbo.SampleData
CREATE TABLE dbo.SampleData
(...

• This reply was modified 3 years, 2 months ago by Ed B.

It sounds very doable and the way you approach it depends on the volume of data.

We extract a lot of data from Oracle using the Attunity drivers, because the built...

This is not an elegant way of doing it, but I think it works. I deleted my first attempt because I was too lazy to convert the values in the...

• This reply was modified 3 years, 2 months ago by Ed B.

Skip my attempt at describing...

duplicate removed

• This reply was modified 3 years, 2 months ago by Ed B.

The code formatting window has gone, but something like this.

DECLARE @JobTime DATETIME2 = '2022-03-14 12:23:45.0000000'

SELECT CASE WHEN EXISTS (SELECT 1 FROM [dbo].[Dst_Time_Conv] WHERE @JobTime >=...

Can anyone suggest how can I first load 100,000 rows from sql tables, create xml file and dump the data into it and then load next 100,000 rows and...

you can put the output into a table. Any east coast date...

Just one more question. If I want for only to appear the fields  'MaxMinDesc' and the 'VacationHours' how would I do it? I have tried taking the asterixes off...

• This reply was modified 3 years, 2 months ago by Ed B.

MinRN is the alias given to the rownumber ordered by vacation hours ascending. The lowest (or joint lowest) will get...

SELECT *,
       CASE WHEN MaxRN =1 THEN 'Max' ELSE 'Min' END AS MaxMinDesc
FROM (
       SELECT...