I'm not using the special characters you listed, but look closely at the code below at how I am using FOR XML PATH to concatenate the values. Incorporate what...

Solomon Rutzky (4/16/2013)

---

Hugo Kornelis (4/16/2013)

---

What Lynn said. 🙂

For ensuring that the empty string is not treated as numeric,...

Well, you printed the SQL to run the backups, what did it look like?

Snippet from your code: PRINT (@Baksql)

mark.gilbert (4/16/2013)

---

I love this article, but I'm bothered by the following scenario...

declare @var varchar(7)

set @var = ''

select case when @var NOT LIKE '%[^0-9]%'

...

Please post the result of this query:

select @@version

Sorry, but there really isn't anything in your post with which to work with here. We can't see what you see.

Pleasse read the first article I reference below in...

Sapen (4/16/2013)

---

I am trying to convert into the below format

week number,

average of sunday,

average of monday,

average of tuesday,

average of wednesday,

average of thursday,

average of friday,

average of saturday,

The averages are nothing but average...

Not too familiar with MERGE myself. ...

This could most likely be done without a loop. As it appears you are also using SQL Server 2008, may I suggest you take a look at the MERGE...

GilaMonster (4/16/2013)

---

Lynn Pettis (4/16/2013)

---

Either nobody has had any complaints, nor needed someone to jump into an issue, or else everyone is just to darn...

Based on the sample data, what would the expected results be?

Seeing if I can get you some more help. What I was going to suggest won't work based on your answer to my earlier question.

Anyone with partitioning expereince may want to jump in here. If the OP was populating empty partitions I had an idea, but putting more data in active partitions (especially...

Lowell (4/16/2013)

---

unlike all of you guys who completed all their tax paperwork in January and already got your refunds back, my yesterday was

non stop juggling of funds so I could...

I just took a close look at the calendar for June. I leave the Sunday after Fathers Day. I wonder if my girls will be doing anything special...