Search results for query: *

Assuming I have a table with months and totals, I need to return the last 6 months of data, with each month being a total of itself and the preceding 5 months. Here's sample source data (you can assume the MONTH to be datetime fields): MONTH QY 7-2008 87 6-2008 33 5-2008 12 4-2008 76 3-2008...

I have a process that is hung and doesn't want to die. I've tried to kill it, I've tried to bounce the service, and then I rebooted the machine. The only change was that the rogue process is now spid 51 instead of its original 53. The spid does appear to have a lock on masterdb and tempdb...

I am trying to import an ADO Recordset into a SQL Server table. All works well if I want to do each row individually, but I'd like to take advantage of batching. I'm using VB.NET and OleDB objects to load a DataAdapter from my RecordSet object. I tie the da to an update command. I also have...

I am trying to import an ADO Recordset into a SQL Server table. All works well if I want to do each row individually, but I'd like to take advantage of batching. I'm using OleDB objects to load a DataAdapter from my RecordSet object. I tie the da to an update command. I also have to loop...

I'm running some simple DDL scripts against a few databases via command line. I see the different tools available but can't seem to find a decent article describing the differences between them. Can anyone here describe the differences or point me in the right direction?

I have an RCCC table with RCCC_ID being an IDENTITY column. The following SQL fails: SELECT RCCC_ID, RCCC_TX, RCCC_TITLE_TX, R.DIR_PROGRAM_ID, R.ACTIVE_CD, CAST(0 AS int) AS RECORD_COUNT_QY, IDENTITY(int,1,1) AS SORT_ID INTO #TMP_RCCCS FROM RCCC R WHERE 1 = 2 with this...

I have a query that needs to compare it's summed results against another set of summed results. When I join to a sub-select in the main query it takes 3 seconds to run. I rewrote it to put the sub-select into a temp table first, then run the second query joined to it directly and it takes less...

I noticed that the Standard version of Studio was missing a few features found in Professional, but I couldn't find a good description detailing those differences. Specifically, the "User Interface" in Standard has only "Simplified menu options and defaults" where Pro has "Full". Can anyone...

I'm sure this is a comon issue, but I just can't seem to solve it - maybe I'm looking too deep... I am trying to migrate a very simple database from SQL Server 2005 to MySQL. When I try to hit SQL Server for the source DB, all I get is connection refused. I've verified all of the connection...

I'm trying to create a CF Scheduled Task to run backround maintenance for an application (auto-archiving old information, disable inactive users...). Works fine on http, but I can't seem to run the same task on SSL. When I try to execute the task I get an instant error message: There was an...

I also posted this in Data Access forum, but with no answers. Can anyone here point me in the right direction? I have a web application that uses many reports. The URLs link directly to the rpt files. Each report is coded to use a predefined DSN. The problem is that we now have have...

We have a new machine, we'll call it JAK_NEWSERVER, with a default instance of 2000 installed on it. When calling @@ServerName, it properly returns JAK_NEWSERVER. Now, the admin troupe has rename the server to just NEWSERVER. They like to make changes. This also renamed the SQL ServerName. I...

I have a web application that uses many reports. The URLs link directly to the rpt files. Each report is coded to use a predefined DSN. The problem is that we now have have multiple instances of the application on the same server, each with it's own copy of the code and database. However...

First, I'd like to apologize for posting a DTS question here. I'm not sure how many SQL gurus actually follow the DTS threads... I am creating dynamic DTS packages in VB to import an Excel spreadsheet into a database table. Since I could not get DTS to work with a #TEMP_TABLE, I upload the...

I am creating dynamic DTS packages in VB to import an Excel spreadsheet into a database table. Since I could not get DTS to work with a #TEMP_TABLE, I upload the data into a static table. The problem lies in that I want more than one user to be able to import data at a time. (The data is...

We are using MS Office 2003 and a VB 6 dll to interface with Excel for data import and export. ( There are several Java solutions to interface with Excel, but I use a VB6 DLL since I need the ability to build custom on-the-fly Pivot Tables. The Java side doesn't yet support that, so I've used VB...

We are having an interesting problem with some dynamic content. We are generating dynamic files (XLS and ZIP) and sending them to the browser using CFCONTENT. <CFHEADER NAME="Content-Disposition" VALUE="attachment;filename=#defaultFile#"> <cfcontent file="#actualFilename#" deletefile="Yes"...

I couldn't find anything in the Search or FAQs sections... Thanks!

I am losing data on import if a column contains both numeric and alpha-numeric data. I have an AN field that usually has only numbers, but sometimes contains alpha characters. The database field is a varchar, and the excel column has been tried as both General and Text. The import seems to...

We use our application at several different locations on multiple servers. (Military stand-alone instances.) I would like to set up my email code to run regardless of whether or not a particular instance has a valid smtp server defined. Currently the cfmail fails if the admin's SMTP server...