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 |
|
Nil35
Starting Member
20 Posts |
 Posted - 2013-09-16 : 13:31:36
|
| I'm converting Excle logice in SQL I dont know how I attch excle file to this massage ..I am using SQL server 2008R2but what i need to do is using Recursice CTE, populated 1st column I want to use that column again in same CTE to populate 2nd column.. 2nd column used to calculate 1st column.Please help me out..Thanks in advance.Nilnil |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-09-16 : 15:18:33
|
quote:
Originally posted by Nil35
I'm converting Excle logice in SQL I dont know how I attch excle file to this massage ..I am using SQL server 2008R2but what i need to do is using Recursice CTE, populated 1st column I want to use that column again in same CTE to populate 2nd column.. 2nd column used to calculate 1st column.Please help me out..Thanks in advance.Nilnil
It is very hard to give any constructive suggestions based only on the information you provided so far. Can you post some sample data and the output you are expecting to get? This blog might help you post data in a form that can elicit more useful responses: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
sigmas
Posting Yak Master
172 Posts |
Posted - 2013-09-16 : 15:27:03
|
| Also you should choose a proper title for your topic. |
|
|
|
Nil35
Starting Member
20 Posts |
Posted - 2013-09-16 : 15:53:33
|
| Thank You so muchnil |
|
|
|
|
|
|
Excle logic in SQL