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 🙂

SELECT

left(Postcode,patindex('%[0-9]%',postcode)-1)

FROM YourTable

where patindex('%[0-9]%',postcode) > 0

order by 3

That should do the trick for all the...

Have all your postcodes definitely got numbers in them? I know they should have but it might be worth checking.