[RESOLVED] SqlServer [2008] Stored Proc. Info needed..

[GremlinSA]

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...

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...

[KrisSimonis]

SELECT City
FROM Table
GROUP BY City

Cake.

[Alsvha]

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...

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...

I think DISTINCT is the keyword for you.

[GremlinSA]

Thanks a mil Kris...

Maybe a piece of cake for you ... I've been doing stored proc's for a month now, with out any sort of guidance.. Just chucked into the deep end.. The .NET side of it i got licked...

Lucky 99% of the project is .NET, with only a few 'Special' calls to SQL....

I need this type of Select statment for 3 Stored Proc's....

Now at least i can continue on it ...

Gremmy....

[KrisSimonis]

Sorry, didn't mean to be nasty. and don't worry.

Here in the deep end, We.. All.. Float.. Gremmy..

Best place to learn it IMHO. Oh, something you might want to check out if you're new to SQL, if it's MS SQL, open your query analyser, type your basic SELECT and hit F1. The Help files of MS SQL are VERY good in my opinion.
Quite exhaustive descriptions of everything, just have to learn the keywords. SELECT, in this case, will show you the full description of the syntax of a SELECT statement. ( duh ), with all the neato tricks you can do to it. and from there, you can read up all the other cool stuff you can do.
In this case for instance, like Alsvha said. DISTINCT would work nicely too.
Take an afternoon reading syntax and examples, browse around in that helpfile and you'll learn a ton.

[GremlinSA]

Not to worry , I know it was not meant to be nasty. And i'm getting used to the deep end ... I've also just found how to merge columbs in a Stored proc ..

So from this....


Now looks like this.....


I'm starting to do more than just float now...

Gremmy...