Hi Debbie

The "running total" update statement - the one with the variables in it - can be a bit quirky. It's best if the data is physically ordered in the...

Debbie Edwards (10/13/2008)

---

Thats exactly what I was thinking....

But I would want it to reset for each person every time it got to the next ECAFST

118007ECAFSTD5028582007-09-102007-09-10 1

118007ECAFMTG5033412007-12-11 2007-12-11 ...

dana_turcanu1981 (10/13/2008)

---

Hi!

I have 2 tables:

CREATE TABLE [dbo].[Tab1](

[Cpt] [varchar](50) COLLATE Cyrillic_General_CI_AS NULL)

INSERT INTO [dbo].[Tab1] ([Cpt]) VALUES('2')

INSERT INTO [dbo].[Tab1] ([Cpt]) VALUES('235')

INSERT INTO [dbo].[Tab1] ([Cpt]) VALUES('234')

and

CREATE...

Hi Debbie

If you are able to add columns to your data set, how about adding a column to identify ECAF groups? This would make reporting on your data much easier....

Hi Ravi

Use a GROUP BY to aggregate the results to SubjectID level:

SELECT SubjectID,

MAX(CASE WHEN ClassID= @FirstClassID THEN ISNULL(CostOfBook,0) ELSE 0.0 END) AS FirstClassCost

MAX(CASE WHEN ClassID= @SecondClassID THEN ISNULL(CostOfBook,0) ELSE 0.0...

Jackal (10/13/2008)

---

Sorry, I'm being a clown, I skimmed over the article to quickly.

I see now the usage of the replace, however this is done in a while loop.

I was...

Yes it is - GSquared posted a tried-and-tested function using REPLACE in the same thread. Problem is, there are so many possible characters to look for.

Hello

GSquared demonstrates an excellent function for this here:

http://www.sqlservercentral.com/Forums/Topic470379-338-1.aspx

Cheers

ChrisM

You're welcome Ronald, thank you for the feedback.

Hi Ronald

Try the following statement.

[font="Courier New"]SELECT *

FROM...

Hi Barry, it's a while since I worked with the product, but back then it was blindingly fast vs the competition when importing files or splitting files as strings into...

Ahah. Thanks for the clarification, Jeff.

Sergiy (10/9/2008)

---

One day some developer will read a conversation like this and decide it's good to use "thorn" character as a replacement for CR/LF.

He/she will agree it with other side...

I'm sorry Joey but that simply isn't correct. Here's part of the WHERE clause from a very similar situation to yours, OPENROWSET with dynamic SQL:

AND CREATE_DTTM >= ''''' + @sDateRangeStart...

DROP TABLE #Sample

CREATE TABLE #Sample (C1 VARCHAR(20), C2 VARCHAR(20), C3 VARCHAR(20), C4 VARCHAR(20))

INSERT INTO #Sample (C1, C2, C3, C4)

SELECT 'a@a.com', '1-Jan-08', 'AAA', 'BBB' UNION ALL

SELECT 'a@a.com', '1-Jan-08', 'CCC', 'DDD'...