Or if you don't need the flexibility of a calendar table (which is probably what I would use) and you don't care about holidays you could do some simple date...

Eirikur Eiriksson (5/1/2014)

---

A simple solution

😎

with p as

(

select 'asdf1234' as Delivery_Site union all

select 'asdf 1234' union all

select ' asdf asdf ' union all

select ''

)

,TXT_INFO AS

(

SELECT

...

Just an fyi...the code you posted is what is known as a multi statement table valued function (mstvf). These are very poor performers. In fact, a typical scalar function or...

See my reply...

Steve Jones - SSC Editor (5/1/2014)

---

That's certainly a bug if it's happening.

All your posts should be editable by you only and I use this button at least weekly....

Try it...

with p AS

(

SELECT 'asdf12345678901' AS Delivery_Site UNION

SELECT 'asd f 234 ...

This certainly works but I...

Good catch below86. The introduction of multiple spaces really messes up that code I posted.

Some people do have problems posting code. It is often their firewall that prevents it. At...

Two major issues with the way you are writing this. The first and the biggest issue is this is wide open to sql injection. You should NEVER directly execute a...

I would think that it is actually slower. Both truncate and drop will deallocate pages. These page deallocations are what is logged in a truncate and a drop. This basically...

jdk77 (5/1/2014)

---

Hi

I have a C# solution with many parameterized sql queries.

I would like to be able to add optimizations to these in a centralized way.

For the sake of simplicity, let's...

dhechle (4/30/2014)

---

I have always believed best practice when writing stored procedures or any SQL code is to include error handling. I was challenged today though as to why include...

SQL Guy 1 (4/30/2014)

---

I need to create a schema in every database, and here is my code that I try to execute dynamically:

DECLARE @stmt NVARCHAR(MAX)=

'use DBApps

GO

CREATE SCHEMA Obsolete...

Bill Talada (4/30/2014)

---

Guids are my preference; I never said they were gospel truth. The difference between guids and identities is that identities get generated on insert whereas guids can...

I don't think that will actually work in all situations.

with p as

(

select 'asdf1234' as Delivery_Site union all

select 'asdf 1234' union all

select...