My advise - create a static Calendar table:

N int,

[Date] date,

DayOfWeek tinyint,

WeekNumber,

LastWeekdayOfMonth tinyint

etc.

Whatever property of a date you may need in your Scheduling tool.

Populate it once, using Tally table.

Calculate and store...

I was tending to say it's not a real situation, therefore I took it out of...

If it's in production code - the developer who did it must be sacked.

If it's in a dynamic SQL - you...

I'd suggest some changes to the design:

CREATE TABLE [ClientApptSeries](

[ID] [int] IDENTITY(1,1) NOT NULL, -- it's good to have a unique ID to use it in JOINs

[ClientID] int NOT NULL,...

What is the difference how fast your query returns a result if you cannot be sure if it's correct?

ScottPletcher (12/22/2015)

---

Seriously, what is the downside to leaving off the N'? I see none, whether the column is char or nchar. But I see a huge downside to...

I must admin - I have quite limited experience...

Minor change to deal with deadlocks:

WITH

cte_Blocks AS (

SELECT

b.spid,

b.typ_of_block,

b.capdt,

b.blocked_spid,

blocked_level = CAST(1 AS INT),

blocking_chain = CAST(b.spid AS VARCHAR(8000))

FROM

#Blocking b

WHERE b.blocked_spid = 0

UNION ALL

SELECT

b.spid,

b.typ_of_block,

b.capdt,

b.blocked_spid,

blocked_level = cb.blocked_level + 1,

blocking_chain...

ScottPletcher (12/21/2015)

---

Eirikur Eiriksson (12/21/2015)

---

Talib123 (12/21/2015)

---

This query has issues due to the \.

If I use a Where = it works fine. How do I get around this small annoying issue.

SELECT name...

Can you post DDL statements for all tables involved in the queries?

Application may "point to" more than 1 database on more than 1 server.

Each method may use its own connection string pointing to a database (or any other data source)...

Then there must be additional column in the CatRange table:

DECLARE @CatRanges TABLE...

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5d2ca35a-2e62-40d1-a4ad-091ed1e5a29f/ole-db-source?forum=sqlintegrationservices

I would not suggest hardcoding category ranges.

They should be put in a table.

This approach dramatically reduces the need in agile development, continuous deployment and questionable technics which became very fashionable...

That's up...