You're welcome. Hopefully it pointed you in the right direction.

I had to update an existing date table to show whether a particular day was a bank holiday in England or Wales or not. The table already had a...

Sangeeth878787 (2/13/2015)

---

The requirement is to see more than 10 Countries, at the moment I have standard dim_date table in my system. Do you want to add 10 extra columns to...

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