David Burrows (11/14/2014)

---

Can there be more than one row in MiniGapp..MG_BOOKING_PARTY table for a BOOKING_ID?

If so how do you determine which one?

If not then you do not need a sub...

pwalter83 (10/10/2014)

---

Hi,

I am working on a report which has a combination of dropdownlist and user entered text parameters. As per the requirement, the values in the user entered text based...

ChrisM@Work (10/6/2014)

---

You need something with which to associate the two tables. Column EDI_PARTNER_CD looks like the only column in MG_EDI_CONVERSION which might be related to COMPANY_ID or COMPANY_NAME.

Do you...

ChrisM@Work (9/12/2014)

---

Choose how you wish to tackle DaysToCount, round up or down or whatever and incorporate it into the function.

CREATE FUNCTION [dbo].[CountFractionalHolidays]

/*

Put in some explanatory notes here

*/

...

ChrisM@Work (9/12/2014)

---

Choose how you wish to tackle DaysToCount, round up or down or whatever and incorporate it into the function.

CREATE FUNCTION [dbo].[CountFractionalHolidays]

/*

Put in some explanatory notes here

*/

...

ChrisM@Work (9/12/2014)

---

-- Following on from the last post, here's the same query as above with a couple of amendments.

-- Firstly, I've put the remaining filters into place, the two...

ChrisM@Work (9/12/2014)

---

Much better, thank you.

2. The 2nd scenario is the issue I am having which is not covered by the function.

If the start date is on a saturday (Sept...

I have amended the post to use 24 hr clock. Hope it seems okay now.

Thanks.

Not really.

If Saturday doesn’t count if it’s after 11.30pm, does it count if it’s 1am? At what point exactly does it change from counting (because it’s 1am and...

ChrisM@Work (9/12/2014)

---

If the existing function has been in use for some time then you should assume that it is tried and tested and wherever it’s in use, any changes to...

ChrisM@Work (9/12/2014)

---

USE TEMPDB

/*

CREATE TABLE MG_COUNTRY([COUNTRY_CD] [varchar](2) NOT NULL,[COUNTRY_DSC] [varchar](35) NOT NULL)

INSERT INTO MG_COUNTRY VALUES ('GB','United Kingdom')

CREATE TABLE [dbo].[MG_BANK_CALENDAR](

[COUNTRY_CD] [varchar](2) NOT NULL,

[BUSINESS_DT] [datetime] NOT NULL,

[BUSINESS_TYPE_FLG] [char](1) NOT NULL,

[DELETED_FLG] [char](1) NULL,

CONSTRAINT [PK_MG_BANK_CALENDAR]...

Paul, you find this type of work very difficult or you wouldn’t be asking for help on a forum. I find it extremely easy – so much so that I...

I hope I...

ChrisM@Work (9/11/2014)

---

Hi Paul

"Number of holidays for country between dates", the name of the function, gives the game away. Are there any holidays which don't last a full day? If there...

David Burrows (8/26/2014)

---

You're welcome...