You searched for the word(s): userid:805100

More Search Options

RSS Available

• sql query to compare the last 2 records

  Hi Frinds, Please can any one tell me the logic of how to compare the last two records I have the table like this Id Number 1 23 2 34 3 23 4 43 5 12 I want to compare the last two records in the above table i.e the numbers have to comapre i.e if 43>13 print "grater" else "lesser" this is the logic for finding the last two records SELECT id,number FROM (SELECT TOP 2 * FROM table_1 ORDER BY ID desc but where I have to write the logic for compare the last two records in above

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by geeta_ravikanti on 7/16/2008

• suggest me code to write trigger

  Hi Friends, Sorry I already posted this question in previously only ,But at that time my question was not clear Please can any one tell me how to write the trigger for the following problem I have to write the triiger for the following table_1 Table_1 contains the following data id Price 1 120 2 121 ----------------- 40 122 41 123 42 111 -------------------------------------------------so on I have 28 records in the first time after that I have to count 13 records i.e i.e 28+13=41 i.e I have to check

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by geeta_ravikanti on 7/15/2008

• Re: inserting the records after 10 elements using Triggers

  Hi Ramireddy, thank you for the reply,I got the answer with while loop but what you suggested is not to use while loop ,yes you ae right but how many times I have to write like (N.Price+N1.Price+N2.Price+N3.Price+N4.Price)/5 as you said above that is I have to write the general statement i.e I dont have to mention the number 5 and N.Price,N1.Price like that and how many times I have to use the innerjoins for adding the average of the prices is there any otherways to implement above query in general

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by geeta_ravikanti on 7/11/2008

• Re: inserting the records after 10 elements using Triggers

  I got the answer ,Sorry for the inconvenience

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by geeta_ravikanti on 7/11/2008

• inserting the records after 10 elements using Triggers

  Hi Friends, I have the table like following table1: Id Price 1 120 2 121 3 123 4 125 5 120 6 110 7 150 8 132 9 121 10 120 11 120 12 212 13 110 14 111 like so on In table 2 : Id Avg 11 avg(price from 1 to 5) 12 avg(price from 2 to 6) 13 avg(price from 3 to 7) 14 avg(price from 4 to 8) 15 avg(price from 5 to 9) like so on..... i.e I want insert the ' avg' in table2 after 10 records are enterd in the table1 i.e I have to check the no of records in the first table For this I wrote the Trigger

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by geeta_ravikanti on 7/11/2008

• Re: don't want to use dataset

  thanQ very much ramireddy Its helped me in another way regards geeta

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by geeta_ravikanti on 7/1/2008

• Re: don't want to use dataset

  thanQ for the reply but have to change in the code or stored procedure but not to use SqlDatSource in front view is there any other ways

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by geeta_ravikanti on 7/1/2008

• don't want to use dataset

  Hi Frineds, I have table with RolseMasterTable with the following fields roleId roleName 1 ceo 2 pl 3 pm 4 tm I have rabiobuttonlist in the form and have to bind the roleName to the radiobuttonlist in the rumtime i.e the values have to taken from the database For this I used the strored procedure and got the result but in this I used the DataSet for filling the date,but I don’t want to use DataSet Here its is the code what I did private void BindRadioButtonList() { SqlDataAdapter daSelectRoleName

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by geeta_ravikanti on 7/1/2008

• Re: finding the age with datedifference

  I changed the code like above then also the previous errors are coming

  Posted to Web Forms (Forum) by geeta_ravikanti on 6/27/2008

• Re: finding the age with datedifference

  Hi cool, I already tried with that ,again I am getting the same above errors

  Posted to Web Forms (Forum) by geeta_ravikanti on 6/27/2008