Recent content by dswitzer

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