ramsai1973 (12/7/2012)

---

Dear all,

I have a table called 'Weeks' which has two columns namely:

1. ID (Primary Key, Auto Indexed, DataType: int)

2. WeekStartDate (DataType: date)

The WeekStartDate column contain dates falling on...

jbon007 (11/29/2012)

---

thanks John it worked.

i've updated the script if others get stuck to a similar problem

SELECT a.Coding_Source, ad.Admit_Date, dd.Disch_Date, pn.Patient_No, w.Ward, ed.Episode_Date,

ROW_NUMBER() OVER(Partition by en.Episode_Number ORDER BY en.Episode_Number)...

Finally finish coding up the php infrastructure for my blog, then start blogging!

Sample data and expected results based on the sample data would be useful. See this article --> http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D, for help on how best to post sample data.

I'm going to guess that the problem is your XML.

Let's take a look at the XML formatted to be readable: -

<Root>

<Node FirstName="Andrew" LastName="Fuller" Email="afuller@contoso.com" Phone="(205) 555 - 9898"...

Jeff Moden (12/6/2012)

---

I don't know what others call this type of problem but I call them "data smears" because it's like you smearing strips of color down from one wet...

The only bug I'm aware of that did something like this was fixed in SQL Server 2005 SP3 CU3 and was never a problem in SQL Server 2008R2 - I'll...

george.greiner (12/5/2012)

---

Cadavre (12/5/2012)

---

george.greiner (12/5/2012)

---

I have to change a prior report which included all records in which DateFinished is in the last 2 weeks to all records in the current month...

george.greiner (12/5/2012)

---

I have to change a prior report which included all records in which DateFinished is in the last 2 weeks to all records in the current month and am...

I agree with Anthony, a calendar table is the way to go.

If you can't create a calendar table for whatever reason, a slower way to solve the issue would be...

Well,...

No problem. Do you understand how it works?

CREATE TABLE #yourTempTable([MonthName] VARCHAR(9), [Year] INT);

WITH CTE(N) AS (SELECT 1 FROM (SELECT 1 UNION ALL SELECT 1)a(N)),

CTE2(N) AS (SELECT 1 FROM CTE x CROSS JOIN CTE y),

CTE3(N) AS (SELECT 1...

In fact, my CTE tally...

Not currently at my desk so the syntax might need correcting, but could you do something like this?

WITH CTE(N) AS (SELECT 1 FROM (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))a(N)),

CTE2(N) AS (SELECT 1 FROM CTE x...