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 |
|
Fergus
Starting Member
2 Posts |
 Posted - 2012-06-19 : 04:45:06
|
| Ok here we go before I start using SQL I need to ask if I can set up a query that looks at say cell a3 all the way to the one before the last cell. I want to do this so I can add columns without having to udpate the query I know in python you can refence lists from the back I was wondering if there is anything like this for SQL?Any help would be appreciatedFergJust seen something like t end? |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2012-06-19 : 06:29:14
|
| Cell? Are you working with Excel by chance?How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
Fergus
Starting Member
2 Posts |
Posted - 2012-06-19 : 07:45:14
|
| That's all i know so far what is it called in a sql database just want to know if its possible to write a query to reference the 3rd value/cell in row three to the second to last in row three.Hope this clarifies |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2012-06-19 : 09:46:14
|
| This is a Microsoft SQL Server help forum. There are no such things as "Cells".Try this link http://www.dbforums.com/microsoft-excel/How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-06-19 : 09:58:54
|
SQL Server isn't a spreadsheet application like excel.The answer to your question is "no".If you need something like that while working with SQL Server then maybe your approach to solve a problem is wrong.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Can I use non absolute cell references?