Search Results

Job schedule

Thread by: sfunds, Feb 18, 2010, 2 replies, in forum: SQL Server 2005 General Developer Questions

I have three scheduled at 7 pm at nightMy daughter changed the system time setting to 2011 which i noticed later and rectified.However the jobs now...

How to query

Thread by: sfunds, Mar 31, 2009, 6 replies, in forum: T-SQL Performance Tuning for Developers

Hi , I download data in csv format. The data has futures quotes for 3 months with following rows Symbol , expiry date , open ,high ,low, close,...

Caculating % change in Closing Price

Thread by: sfunds, Jun 8, 2008, 1 replies, in forum: General Developer Questions

I have a table with following fields Date closePrice symbol I have to calculate % change in Closing Price compared to prvios day price for all...

Tuning

Thread by: sfunds, Sep 19, 2005, 13 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I have SQL SErver 2000 The database consist of 2 tables Table 1 having details like company name,code etc. The second table the important one...

executing stored procedure on sql server from

Thread by: sfunds, Jul 26, 2005, 7 replies, in forum: General Developer Questions

Hi, How to call stored procedure from from Sql Server on another with parameter thanks

Query too get 10 th ,30th row etc

Thread by: sfunds, Jul 25, 2005, 6 replies, in forum: General Developer Questions

Hi, I need a query to do the following. I have a table which has stock name, stock symbol,date and close price. Stock symbol and date are primary...