I'm getting closer...

try something like this:

SELECT phone

, FixPhone

, LEFT(FixPhone,1) + '-(' + SUBSTRING(FixPhone,2,3) + ') ' + SUBSTRING(FixPhone,5,3) + '-' + SUBSTRING(FixPhone,8,4)

FROM (

SELECT phone

, CASE WHEN LEFT(phone,1)='1' THEN REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(phone,'(','.'),')','.'),'.',''),'-',''),' ','')

ELSE...

Maybe this article will help get you sorted out

http://www.sqlservercentral.com/articles/T-SQL/63681/

First things first - we need to understand what you really mean by this:

I want email sent with the above data in html table format and only if col3 values...

This article[/url] looks good.

Kevin,

This design worries me. Can you please describe the business problem you're trying to solve? I would be willing to wager that what you're trying to do would...

I answered this already here:

For a minute I thought my post disappeared... then I realized you were double-posting. While I realize that you may feel that double-posting gets you...

I'm pretty sure Eirikur will shred my SQL, but this works:

SELECT MatchID

, MatchDate

, TeamID

, PrevMatch

, DaysElapsed

FROM (

-- get the difference in days between matches

SELECT MatchID

, MatchDate

, TeamID

, LAG(MatchDate,1) OVER (PARTITION...

The really short answer is to use a tablix with two columns (StartOfWeek, WorkHours) inside of a matrix with a ColumnGroup on MonthNumber.

Which means you need to add a calculated...

Why not create a UNIQUE constraint on the table and disallow the duplicates that way?

I may just spend some AmazonBucks on them. Ferrari's book looks really good. Might have to find some tutorials on MDX too, but one thing at a time.

Thanks...

Your English is fine! (the sample data is a huge help!)

Here's the sample data in a useable format:

SELECT 49 AS WeekNo, 28...

Sorry, can't remember if any windowing functions were available in 2008R2. Haven't used 2008 in an age (partly because windowing functions are super handy!)

I would probably bring all the data down into Access and index the tables -- after you have all the data. Then build your query there. When you're...

One option is to do this with a windowing function, like this:

SELECT ProductID

, Sales

, SUM(Sales) OVER (ORDER BY Sales

ROWS BETWEEN UNBOUNDED PRECEDING

AND CURRENT ROW) AS RunningTotal

FROM (SELECT 1 AS ProductID,...

Exercise your GoogleFu... There are examples all over the place, especially on the MS website...

http://msdn.microsoft.com/en-us/library/ms190307.aspx

See example B.