Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blackX
Posting Yak Master
102 Posts |
 Posted - 2008-12-17 : 13:46:09
|
| In our database applicaton we have a notes field that concatenates the new notes to the old notes. It is always entered asDateTime, UserID, NewNotes Here, Old notes here (consisting of same pattern of datetime, userid, notes). I need to a query to return the member_id and number of times new notes were added, which could be achieved by counting the number of dates or userIDs. Is this possible? Thanks in advance |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-12-17 : 14:46:32
|
| how are they concatenated? new line? any other delimiters? |
 |
|
|
blackX
Posting Yak Master
102 Posts |
|
|
|
|
|
count number of occasions a pattern appears