Get relevant Cell values - 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)

Get relevant Cell values

Author

Topic

ramzansadiq
Starting Member

6 Posts

Posted - 2009-06-10 : 15:27:28

Hi there,

I have a table which has all excel cell values(a1,a2,b1,b2 and so on) , I want to pass single cell value which will return all relevent cell rows.
1. If I pass a1 output rows will be ( a1,a2,b1,b2)
2. If I pass d4 output rows will be ( c3,c4,c5,d3,d4,d5, e3,e4,e5)

It will also include passing cell.

Help is greatly appreciated

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-10 : 15:51:16

Can you post your table structure?

E 12°55'05.63"
N 56°04'39.26"

ramzansadiq
Starting Member

6 Posts

Posted - 2009-06-10 : 16:23:16

Thanks for ur reply

I didn't create this Db and have limited info. This table doesn't depend on any other table.

Columns are

ID(auto numbers), Cell Values(a1,a2,..-varchar(2)), Plan_Fee(doesn't match for this criteria-number), Prop_Fee(doesn't match for this criteria-number), Geometry (describing all the coorindates ).

This is GIS Table.

waiting for your reply.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources