HOW TO SPLIT AND COUNT - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

HOW TO SPLIT AND COUNT

Author

Topic

sateesh.sqldba
Starting Member

25 Posts

Posted - 2010-07-17 : 02:41:23

Hi experts,

i have problem like this

COL1

IMG
IMG1
IMG2
IMG1,IMG2
IMG,IMG1

I NEED TO SPLIT IMG1,IMG2 AS IMG1 AND IMG2 MOREOVER I NEED TO COUNT

GROUP BY COL1 THAT IS LIKE
IMG 2
IMG1 3
IMG2 2

PLZ PLZ HELP ME OUT

sateesh

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-07-17 : 02:43:34

look on internet for splitstring query: http://blogs.vbcity.com/hotdog/archive/2008/06/04/9085.aspx

and then perform a simple count and group.

sateesh.sqldba
Starting Member

25 Posts

Posted - 2010-07-17 : 08:39:47

quote:
Originally posted by slimt_slimt

look on internet for splitstring query: http://blogs.vbcity.com/hotdog/archive/2008/06/04/9085.aspx

and then perform a simple count and group.

plz will u explain how it work for me,I am knew to this topic

sateesh

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-07-17 : 09:43:14

already answered in your other thread http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=147403

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources