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 |
|
uday_forum
Starting Member
2 Posts |
 Posted - 2006-11-14 : 08:10:05
|
| Hi everybody, I have a table cateory in which i have a column called CategoryName.I would like to display the categoryname in the following order.2 Records of each category name starting with alphabet from A to J visa versa K-P and then finally Q-ZPlease help me out either by query or by stored procedure.Regards,Uday |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-11-14 : 08:14:29
|
| You are going to have to put a tiny bit of effort in here and show an example.Jay White |
 |
|
|
uday_forum
Starting Member
2 Posts |
Posted - 2006-11-14 : 08:29:03
|
| Hi Jay,Thanks for your reply.Let me give the URL of my web page. http://www.rankhigh.org/labecxver2.0/index.htmlin this URL you will find Category heading and below that you will find A-J, k-R ...Under each heading for example A-J, i have to pick up 2 category names [Apple, Amozon] and then [Books, BATS] etcIm using C# and SQL Server as my backend.Hope the above information is sucfficiant for you.Awaiting for your early response.Thanks in AdvanceUday |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-11-14 : 09:44:24
|
| YOu need to provide us with your table structure, some sample data, and how you'd like results to be returned. We have no idea how your data is stored and what specificly you want back other than a vague concept; let's eliminate all the guesswork and make it easy for us to help you and to ensure that you get exactly the solution that you need. Makes sense, right? - Jeff |
|
|
|
|
|
|
display category names A-J, K-T