Shouldn't that be SQL Bits 1100 or something?

Thanks for reading it Wayne. Comments from a master such as yourself are always most welcome.

BTW. I think we're tied again on article count. 😀

You're welcome. No e in my name though. 😀

Strange. I would have thought something like this would be faster:

CREATE FUNCTION [dbo].[RemoveUnmatchedPatterns]

(

@Str VARCHAR(8000)

...

Roy.G.Biv (2/27/2014)

---

We began with a succession of efforts to apply Excel macro code entered as a function to obtain medians in a filtered worksheet list of scores of thousands of...

If you've got a Calendar table you can use it but I've constructed one in line to solve this:

WITH SampleData (PERSON, [DATE], [PAYCODE],[HOLIDATE]) AS

(

-- First employee...

You probably need something like this:

WITH ConsolidatedTables AS

(

SELECT prefix, rate, T='data1'

FROM dbo.data1

UNION ALL

SELECT prefix,...

David Webb-CDS (2/26/2014)

---

Don't know about the date, but this looks like it puts in the control characters correctly:

alter PROCEDURE dbo.Test

(

--@Dt DATETIME = '20140201'

...

Something like this?

CREATE TABLE #MTRANS

([MTRANS_ID] int IDENTITY (1, 1) NOT NULL,

[MBatch] int NULL,

[MStatus] ...

I believe that default values must be literal constants and cannot include built-in functions.

This fails also:

CREATE PROCEDURE dbo.Test

(

@Dt DATETIME = GETDATE()

--,@tab VARCHAR(1)...

andrew gothard (2/26/2014)

---

dwain.c (2/26/2014)

---

kenneth.mofokeng (2/26/2014)

---

Since you don't have backup...

Can't say I see that much of a resemblance but it is always good to hear...

kenneth.mofokeng (2/26/2014)

---

Since you don't have backup , try to...

ChrisM@Work (2/26/2014)

---

Stefan Krzywicki (2/25/2014)

---

The Dixie Flatline (2/25/2014)

---

rodjkidd (2/25/2014)

---

Steve Jones - SSC Editor (2/24/2014)

---

I went to the Rock and Roll Hall of Fame in Cleveland a few weeks ago. It was...

As Luis has said, any direct help from this forum is going to need you to provide us DDL, sample data and expected results.

But at a guess, I'd say there...