Luis that will work with two...

I will assume you didn't actually run these inserts. It is chock full of syntax errors. The dates don't have quotes around them and there appear to be lots of...

LOL Lowell you really pulled out all the stops with your T-SQL hammer on this one!!! Talk about brute force. I don't remember the link to the hammer on your...

Like this?

;with SampleData (val) as

(

select '51079-216-20' union all

select '3456-435623-45-34'

)

select left(replace(val, '-', ''), LEN(replace(val, '-', '')) - 2)

from SampleData

Please take note of how I posted sample data to make it easy...

If you want to prevent locking your table for an extended period of time you can do this in batches.

--This will ensure that the value of @@ROWCOUNT for the...

kak.mca (11/8/2012)

---

RowIdENameProjectTime partHours

Worked[14 Jan][15 Jan][16 Jan]

1Emp 1Project 114/1/20107.0

2Emp 2Project 215/1/20108.0

3Emp 1Project 116/1/20108.0

From the above table:

The above table is showing like

Emp 1 has worked for 7.0 hours on Project 1 on...

I would not do this in sql. This sounds like you need a simple program to do this. If I had this assignment I would generate a .net windows service...

If this is the worst QotD you...

huestetwins (11/7/2012)

---

Sean,

Thank you so so much, after tweaking it a bit, it works perfectly in our procedure. My developer is over the moon happy.

And the function is...

OK I used your #mytable as the basis for this. I removed the identity from ID so the inserts would work. 😉

CREATE TABLE #mytable

(

ID INT PRIMARY KEY CLUSTERED,

summarytext varchar(max),

billid int,

);

INSERT...

huestetwins (11/7/2012)

---

Thank you so much.

I'm reading the article and realize this is something that can help in our environment. I created the function and ran the query...

sa06rdy (11/7/2012)

---

Hi,

EDD script gives the Distinct Admission numbers from the admissions table from apr2012 to current which are satisfying the conditions given.

TEP gives the total Patients from apr2012 to...

Thanks for the ddl. Can you post at least a couple of rows of sample data, it does not need to be real data assuming it might be sensitive. Just...

sa06rdy (11/7/2012)

---

Thanx Sean,

At present the script will just calculate Numerator/Denomenatorx100 from 2012-apr-01 to current date.

I am looking to split the result for each individual month aganist each ward.

Sample Output...

stephenmbell (11/7/2012)

---

I am very far from an expert when it comes to working with xml - but I have some exposure to it. I was recently given a project...