Search results for query: *

Hi Boomerrang, Yes I had the same problem with the click event. It does not seem to drop the DropDown selection bit. I like your idea, however, I am not looking to make it into a listbox just keep a DropDown. I wonder if there is anyway of getting rid of the scroll bar on the right of the...

Hi, I am looking to get a Drop Down box to drop down when it recevies foucs, through Javascript. Can anyone help? Raj.

You have placed the Group By in the wrong place on all the Statements. Try the following UPDATE SecCounter SET HHigh = Max (SELECT TOP 200 C.High FROM CONS C WHERE C.CounterName = S.CounterName GROUP BY C.CounterName ORDER BY CounterDate DESC ) , CloseV = Max (...

Ok, well i have joined and am no longer a visitor. Max I assume you don't have an ID on the records already and that is why it is taking so long..... because your creating a temp table with 100000 records to number them. I would suggest a cursor but that would just take as long... I am...

ASSUMING you have a unqiue numeric ID on the Table somewhere then you can Generate a Set of 5,000 - 10,000 numeric IDs and then just join the tables and extract the records. (IF you don't I guess as a one off you could just add them) Here is code to Generate Random int ID's and then you just...