|
-
April 24th, 2008, 04:14 AM
#1
[RESOLVED] SqlServer [2008] Stored Proc. Info needed..
I can do some simple stored proc's, however for the project that i'm busy with i need a 'Special' Stored proc to return Unique entries from a specific col..
I have a table with Suburbs, Postal code, and City...
Code:
Uid Suburb Code City
1 Que 2015 JHB
2 Kelvin 2017 JHB
3 Turf 2091 JHB
4 Bla 3082 VDB
So i need to select all unique City's from the DB to populate a Combobox.
I've previously done this all within the app or used a seperate DB to hold the City, however in this app i'm following the clients 'Preset' layout and trying to follow as close as posible...
Thanks ...
Gremmy...
Articles VB6 : Break the 2G limit - Animation 1, 2 VB.NET : 2005/8 : Moving Images , Animation 1 , 2 , 3 , User Controls
WPF Articles : 3D Animation 1 , 2 , 3
Code snips: VB6 Hex Edit, IP Chat, Copy Prot., Crop, Zoom : .NET IP Chat (V4), Adv. ContextMenus, click Hotspot, Scroll Controls
Find me in ASP.NET., VB6., VB.NET , Writing Articles, My Genealogy, Forum
All VS.NET: posts refer to VS.NET 2008 (Pro) unless otherwise stated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|