Search results for query: *

A big, ugly query is what I was afraid of. If it's a simple self join that I missed I'd be ok with it. It's already working well enough with the loop, it would just be nice to have an all-encapsulated *simple-to-understand* query. I'll keep the loop unless someone comes up with something...

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

Please excuse my earlier retardation. My other laptop was maintaining a second connection to this database. I was my own worst enemy... :D

The status is "runnable" and it's current command SELECT INTO. This is on my local machine. I don't get any error messages at all, either through the Enterprise Manager or from Query Analyzer. It just doesn't die. Why would the process persist even after a hard reboot? Thanks for any info...

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

Is there any way to do this at runtime when NOT using VStudio? We are web-based and run the .rpt file directly from a URL. We want to use the same rpt file, but point to different database at runtime. There seems to be no way to specify a DSN at run-time to change what's already embedded into...

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

After a brief redirect, I'm finally able to get back to this problem... I've created a global variable from a param passed into main function: Dim objGlobal As DTS.GlobalVariable goPackage.GlobalVariables.AddGlobalVariable "USER_ID", user_id I'm not sure how to use it though. Do...

After a brief redirect, I'm finally able to get back to this problem... I've created a global variable from a param passed into main function: Dim objGlobal As DTS.GlobalVariable goPackage.GlobalVariables.AddGlobalVariable "USER_ID", user_id I'm not sure how to use it though. Do I...

Is it still possible to pass the reports to a web page that load the ActiveX viewer? I'm not sure if OCX methods were still supported in version 9. If it is, can someone point me to the OCX and post a small usage example with parameters and a connection string? The solution I need is to be...

Is it still possible to pass the reports to a web page that load the ActiveX viewer? I'm not sure if OCX methods were still supported in version 9. If it is, can someone point me to the OCX and post a small usage example with parameters and a connection string? The solution I need is to be...

Looks like it should work, thanks! I'll try it once they put the box back online...

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