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 |
|
Guruprasath.cub
Starting Member
8 Posts |
 Posted - 2012-04-28 : 05:32:50
|
| I have two / three difference sql table. I need to call-out the data keeping one "Ref.No" as reference number, which present in all the three table. In second table, there are multiple rows for the same reference number. But I need to call out one particular row of that table making a "where" condition.In the third table also the same where I need to use "where" condition and the selected value with "Mac(value)".This works out in the sql command window, but when I use in the asp .net, I am unable.Please could you help hereGuru |
|
|
Guruprasath.cub
Starting Member
8 Posts |
Posted - 2012-04-28 : 05:37:41
|
| I have two / three difference sql table. I need to call-out the data keeping one "Ref.No" as reference number, which present in all the three table.In second table, there are multiple rows for the same reference number (with different item codes). But I need to call out one particular row of that table making a "where" condition for the particular item code.In the third table also the same where I need to use "where" condition and the selected value with "Max(value)".This works out in the sql command window, but when I use in the asp .net, I am unable.Please could you help hereGuru |
 |
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-04-28 : 05:39:50
|
| If the query works fine in SSMS then it is not a problem with SQL Server. It could be a problem of a coding error that you could be making in your ASP.net code.This is an SQL Server Forum.....you could get a better solution for this problem in a .net Forum.N 28° 33' 11.93148"E 77° 14' 33.66384" |
|
|
|
|
|
|
asp coding with sql database