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'...

Hey hey now -- what you do in the privacy of your own cubicle is your business, but this is real, valuable data I need to show...not some kind of crazy dog and pony show.

Oh -- very cool idea. That sounds like it will work. Thanks.

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...

Easy enough - I had a big fancy solution in mind -- but scheduler works for me! Thanks. Dave

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 got it. The default Manufacturer in the installer was set to '.' -- so when the installer wanted to install to c:\program files\.\ -- that was an issue... Easy enough.

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...

LOL

Thanks to all. I have been running automated Excel macros and then secondary jobs in SQL2000 -- not too robust but with a little elbow grease it has been running... Between Dennis' code and this link: http://www.codeproject.com/KB/vb/webresourceprovidernet.aspx I understand how to get...

Thanks - they had it there: http://www.tek-tips.com/viewthread.cfm?qid=1071852 strSoundFile = "c:\070-who2.wav" Set objShell = CreateObject("Wscript.Shell") strCommand = "sndrec32 /play /close " & chr(34) & strSoundFile & chr(34) objShell.Run strCommand, 0, True

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

Good question - but no. I ran through the process again -- watching the task manager -- never more than one Excel window open...

You know - I tried that yesterday -- and I just tried it again and it did not close the app window...very odd...no errors, the code was "recognized" when I added it -- as it capitalized the code to Application.Quit It just didn't work. Is there a setting somewhere that I am missing? The...

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...

Thanks guys - that does the trick.