This will be a lot easier if you've got a calendar table. This one[/url] is a good place to start. You might have to modify it to show...

It's funny. When it snows in my area (usually get 1 snow/ice storm per year, of no more than 4 to 6 inches), we get all of the people...

Try this one[/url] first. There's many out there so a little searching might find one that does exactly what you need. Working days vary from country to country...

Have you got a calendar table? That will make the calculation of working days much easier.

Plane

Gang

Bond

My cousin's daughter once said 'I know its a boys' job, but I want to be a scientist when I...

You're welcome.

Edvard Korsbæk (2/4/2015)

---

Hi All!

I have this table:

[dbo].[Login_details](

[login_data_id] [int] IDENTITY(1,1) NOT NULL,

[login_no] [int] NULL,

[logindate] [datetime] NULL,

[logoutdate] [datetime] NULL,

CONSTRAINT [PK_Login_details] PRIMARY KEY CLUSTERED

(

[login_data_id] ASC

)

This query:

Select count(*) from dbo.Login_details group by...

Sqlraider (2/2/2015)

---

Iwas Bornready (2/2/2015)

---

Sometimes (always?) it just comes down to time and money. I can give it to you quick and dirty today or elegant tomorrow. If I go elegant...

Lock

bugg (1/30/2015)

---

Mark Cowne (5/3/2012)

---

Join to a numbers/tally table

SELECT s.ORDER_NUMBER, s.PRODUCT_ID, 1 AS QTY, s.VALUE/s.QTY AS VALUE

FROM @SPLITROW s

INNER JOIN master.dbo.spt_values t ON t.type='P'

AND...

TomThomson (1/26/2015)

---

Nice straightforward question.

Half the people who have replied so far think they can use a column filter to select rows, which is a bit startling; and more than four...

You're welcome. I've done some tinkering with postcodes myself in the past so I recognised what you were trying to do 🙂