Would a T-SQL option help?

http://www.sqlservercentral.com/scripts/SQL+Server+2005/67515/

Here's an option that doesn't need additional functions.

This will fail without warning if the street name has a number.

DECLARE @SourceTable TABLE (

ID INT IDENTITY(1,1)

,...

joanna.seldon (10/4/2016)

---

Hi

I have got this far using your query

SELECT dateadd(hour, datediff(hour, 0, a.StartDate ), 0) as TimeStampHour, Count(*)

FROM Database.dbo.MainTable a

Where a.StartDate >='20160101'

and a.Department like 'Catering%'

GROUP BY dateadd(hour, datediff(hour,...

Why would want something like that? It's overrated. Especially when you have a bunch of experts at your service handling crystal...

Hi Alan, you're still missing the GetNumsAB definition. I'd be interested on checking out how everything works. 🙂

Lynn Pettis (10/3/2016)

---

Okay, post a question then a few minutes later post an "answer" that they say works and not to post to that thread. Fine, except what was...

patla4u (10/3/2016)

---

If I use maxrecursion in query, is this change server level the thesold or database level ?

Can I implement in production ? What is the advantage and disadvange...

jasona.work (10/3/2016)

---

Ugh...

Those of you in the US might have heard about the "creepy clowns" that seem to be popping up all over the place, especially the one down in Georgia...

If you post your code with sample data, you might get an alternative to the code.

The reason to prevent the use of maxrecursion is that it might not be necessary...

The simple answer would be to use something like this:

DECLARE @myv VARCHAR(MAX) = 'AB,CD,EF,GH,IJ';

WITH

E(n) AS(

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

),

E2(n) AS(

SELECT a.n...

andrew gothard (10/3/2016)

---

To me, they're not really the same thing. MySQL is more of a replacement for xBase than a proper enterprise product, it's certainly nowhere like Oracle or...

Google the functions and change them to the Access...

Since you only want an example, here's one that works on SQL Server.

If you want to make it work on Access, you have to find the correct function names and...

ZZartin (10/3/2016)

---

It...

I know what you're trying to do. What you fail to understand is that to get the correct calculation, you need to be able to define how to calculate week...