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 |
|
kulkarni_ajit
Starting Member
4 Posts |
 Posted - 2009-02-23 : 03:49:19
|
 Hi, Import the table structure attached along with the data.What we are trying to achieve here is that we need to have a search which will give me group where the matching values will be available for eg. I will give search1. Location = ‘Pune’ and Year = ‘10/10/10’ Then the query should give me groups 175,1772. Location != Pune and Year =’10/10/1010’Query should return me group 1763. Location = Pune AND time = ’11:11:11’ AND Year = ‘10/10/1010’Query should return me group 1774. Company != OracleQuery should return me 179 and 180So what we are trying to do is that we are creating the table structure dynamically and the corresponding values for each column the columns are user defined.We did try using Having clause but it is not working for multiple rows ?Please let us know if you need more inputscan i do in Single SQLplease help me outRegardsajit |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
please help me on this Tricky SQL