Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TheDrider

    Rolling SUM of last N rows - grouping question

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

    Rolling SUM of last N rows - grouping question

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

    Can't kill a process

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

    Can't kill a process

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

    Can't kill a process

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

    ADO.NET batchUpdate doesn't work with OleDbDataAdapter

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

    batchUpdate doesn't work with OleDbDataAdapter

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

    Change DataSource at run time using .NET 2005

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

    ISQL vs. ISQLW vs. OSQL?

    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?
  10. TheDrider

    SELECT INTO fails for tables with IDENTITY

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

    Query with Sub-Select takes longer than a temp table

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

    VS .NET 2005 -- Standard vs Professional?

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

    Migration from SQL Server 2005

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

    Scheduled Task on SSL

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

    Can I import a static value with my spreadsheet

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

    Can DTS include a static column?

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

    Dynamic DSN using the Web Component Server

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

    Dynamic DSN using the Web Component Server

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

    @@ServerName not returning actual server name

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

    Dynamic DSN using the Web Component Server

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

Part and Inventory Search

Back
Top