Search results for query: *

Sample data, data is sorted by date asc: ID[tab] date 123[tab]4/1/15 555[tab]1/1/15 123[tab]4/15/15 123[tab]4/25/15 555[tab]1/20/15 I'm looking to add a new column calculating the difference between dates from previous record with matching ID. So the results should be: ID[tab] date[tab]...

-- sample data CREATE TABLE #A ( refNum int,idA1 varchar(3),idA2 varchar(3)) CREATE TABLE #B ( refNum int,idB1 varchar(3),idB2 varchar(3),idB3 varchar(3),idB4 varchar(3),idB5 varchar(3)) insert into #A select 1,'001','999' insert into #A select 2,'002','999' insert into #A select 3,'003','999'...

I want a chart similar in concept to: http://www.edwardtufte.com/tufte/posters Basically in excel I want to have (instead of a line) -- a wide line that I control with data -- the line varies in thickness according to data (much like Napoleon's army dwindles in size through the Russian...

I have an app I want to run at the following days/times: 1.only on weekdays 2. only between 8:50am-3:30pm 3. at 15 minute increments So, Mon-Fri it would run at: 8:50,9:05,9:20... When it is not running -- I want to use a minimal amt of cpu obviously. Thanks for your input. Dave

I built a windows app in VB.NET (VS2005) and am having issues in deployment. I have to warn you -- this is one of my first deployments. I get an error: The folder path '.' contains an invalid character." So - I thought maybe something was wrong with my app -- so I followed the VS walkthrough...

I have cobbled some code together from various places that reads a webpage's source code, mostly from this guy Ravi: ' code adapted from original c++ library from ' Ravi Bhavnani <ravib@ravib.com> ' http:'www.codeproject.com/internet/WebResourceProvider.asp. ' Copyright (c) 2002. All Rights...

Has anyone looked into playing a sound through a DTS pkg? A simple beep would be a great start... Any ideas? Thanks. Dave

I am using a .bat file to call a workbook -- it will run a macro, and then close. The .bat file works fine and is simply: call C:\test.xls In the spreadsheet, I have Private Sub Workbook_Open() Call macro1 Call workbook_close End Sub Private Sub workbook_close()...

I'm having trouble finding a way to trigger an event at a specified time. How can I set something off at say: 5:30pm every day without using a lot of system resources? Thanks. Dave

SQL 2000 I am setting up a database of stock data to play with. Nothing huge. My current import process is to gather the stock info in Excel through some macros that grab stock data from yahoo. Then I import that into SQL. Has anyone done anything like this straight through SQL (so I can...

SQL2000. I have a dataset: seqNum value 1 30.25 2 31.25 3 32.25 4 30.00 5 28.30 6 29.50 7 28.00 8 28.00 9 28.00 10 28.00 11 28.00 I am trying to write a sql statement that returns each record + checks 5 sequence #'s forward and returns the...

2 questions (SQL2000): 1. how can I truncate the decimals: 3205.15 --> 3205 3199.99 --> 3199 3155.00 --> 3155 2. How can I round down to the hundreds: 3205.15 --> 3200 3199.99 --> 3100 3155.00 --> 3100 If someone can point me in the right direction, it would help. Thanks. Dave

CR XI. Printer wants the output in "printer spread" -- which means instead of pg1,pg2,pg3...pg16 he wants it in order for the booklet so pg1,pg16,pg2,pg15 -- so he prints 2 pages on 8.5x17 and then folds it into a booklet. This wouldn't be so bad if it was a static 16 page report -- but...

I am trying (CRXI) to force reports to print out with a multiple of 4 pages. So, if the report is 10 pages long add 2 blank pages 2+10=12. If the report is 17 pages long - add 3 blank pages 3+17=20. If the report is 12 pages long -- no need to add pages. and so on. So, the way I see it -- I...

My sp (SQL2000) is very simple -- pulling data from a table based on an input paramater. When I run the sp in Query Analyzer - it is fine. When I run it through ASP -- 0 records. That is the count - zero...no data whatsoever. However, if I eliminate the where clause inside the sp and just grab...

I'm sure this has been answered many times before on this forum - but I don't seem to be able to find it... I have an sp(SP#1) built to insert records into a table (Table A). This sp is used extensively by users and works great. I am building another sp -- more of a back-office function. If...

I have a summary page that looks up various pieces of data in other pages (same workbook). I would like to copy the formulas down instead of editing (or find/replace although that is an option). For example: sheetName formula sheet1 =if(sheet1!A1=sheet1!A2,"OK","ERR") sheet2 If I copy...

Is there any limit to the number of subreports that I will run into? I am creating an extremely detailed report in CR XI using a SQL Server 2000 back-end. The report has over 60 pages of metrics -- and on each page, around 6 subreports showing various datasets in tables and in charts. So I am...

CR XI - SQL Server 2000. I have a dataset like: cat catflag ct 5 0 10 6 0 12 7 1 8 8 0 15 9 0 20 I want to create a bar chart in crystal where the bar with the flag set to 1 is a different color than the other bars. Is this possible? It...

SQL Server 2000. I have a table ~8 million records. I have a clustered index on the two fields that I use for querying parameters (idNum,qtrdt) -- and the queries are nice and fast. I have a maintenance process where I need to delete all records in the table with qtrdt='yyyy-mm-dd'. My...