Please don't use a recursive CTE to generate a calendar table as it's only a way of hidden RBAR. You can read more about this on this article: http://www.sqlservercentral.com/articles/T-SQL/74118/

As an...

The simplest way was to use the original query as a CTE or derived table and then join it to the calendar table.

WITH cteQuery AS(

SELECT RTRIM(data.dbo.CLI.LNAME)...

Isn't that a connection property?

What exactly do you want to know? Does this answer your question?

You need an outer join with a calendar table.

Something like this:

SELECT *

FROM CalendarTable c

LEFT

JOIN SomeTable s ON c.calDate = s.SomeDate

WHERE c.calDate >= @StartDate

AND c.calDate < @EndDate + 1

In this case, you don't need to know the types from the columns as they won't matter. The important part is to know the type the function returns.

From BOL

---

COUNT works...

This should work as explained in the original post. It doesn't return the same results because you don't have digits in your AllowedCharacters table.

CREATE FUNCTION dbo.StripNonAllowedChars

(

@OriginalText Varchar(8000)

)

RETURNS...

Lowell (8/10/2015)

---

yes, there's a reason!

i built this a while ago , and i have a bunch of variations of it for specific purtposes.

but i...

Any reason not use LIKE?

ALTER FUNCTION dbo.StripNonAlphaNumeric_itvf

(

@OriginalText Varchar(8000)

)

RETURNS TABLE

AS

RETURN

(

WITH tally (N) as

(SELECT TOP 10000 row_number() OVER (ORDER BY sc1.id)

FROM Master.dbo.SysColumns sc1

CROSS JOIN Master.dbo.SysColumns...

Virus

After a good weekend of rest and a morning coffee, this is what I came out with. It's reducing the conditions by splitting the lines into separate rows before the...

Your data doesn't help that much. It allows basic tests and I can't be sure that all conditions are met.

You'll have to test this code to be sure that it...

nadersam (8/9/2015)

---

Hi Luis,

Please bare with me, i am new with tally tables programming, i was reading about it during last few days.

In our example you specified the number of rows...

5 more to get to page 1K for me.

Jeff Moden (8/7/2015)

---

SQLRNNR (8/7/2015)

---

jasona.work (8/7/2015)

---

Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we...

Hugo