Recent content by deepthiv

Thanks a lot Ryan.. It helped me

If you are using datareader u can test with if dr.HasRows = false then MsgBox("No rows returned") --deepthi

hi, can anyone please tell wht's the query to check if database exists, if exists list all tables in database (in sqlserver) else raise error Thanks in advance, Deepthi

Thanks lot jon.... It worked for me... Thanks again....(now i have only minor differences)

yes true jon.. it's correct.. but why it's deviating for 2000 + records?? ok...'!!! can we think in this way... Is there any sql query that can find nth percentile of given column... ( here my database is excel and want to display percentile in web page) :-) not sure why i am facing this...

One more info... here i am reading excel column values into recordset -(output of ' select col1 from table1') and reading record set value (till rst.Eof) in to array and using this array in Percentile function.... any help on this? regards, Deepthi

Thanks a lot jon.. This is gr8 code.. I have to calculate percentile on entire column which has nearly 2000 rows and each value has nearly decimals upto 6 to 7 points . and now i am getting differences in percentile values when calculated from excel percentile formula and using VBA...

Any insert command to load Oracle profiler log data into table... ??

thanks jon.. for ur reply but in VB.NET i am getting error saying "Unable to get the Percentile property of the WorksheetFunction class" for X1.WorkSheetFunction.Percentile(dblData, p).. i am breaking, can some one please...

i am using Excel Object API in VB.NET Dim X1 As Object X1 = CreateObject("Excel.Application") Dim res As Double = X1.WorkSheetFunction.Percentile(dblData,p) here is dblData is array of type double which has recordset column values, There is an exception saying. "Unable to get the Percentile...

i am using Excel Object API in VB.NET Dim X1 As Object X1 = CreateObject("Excel.Application") Dim res As Double = X1.WorkSheetFunction.Percentile(dblData,p) here is dblData is array of type double which has recordset column values, There is an exception saying. "Unable to get the Percentile...