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 wOOdy-Soft 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: *

  • Users: RogueSuit
  • Content: Threads
  • Order by date
  1. RogueSuit

    How do I reduce the # of DPC's while running a SP?

    I have as stored procedure that creates a ridiculous amount of overhead. The processor reaches its maximum due to a high DPC count. I visited Microsoft’s Tech Net site and it mentioned something about needing to check my network hardware or upgrade my processors on my SQL box. The query...
  2. RogueSuit

    Stored Proc creating 100% load on processor #1

    When ever I run this stored proc my SQL servers processor immediately hits 100% usage and the proc runs for quite a while (The table this runs from has over 9.7 million rows with 4 indexes). The 4 indexes were created based on the fields called in the where clauses. Any suggestions for...
  3. RogueSuit

    Using the "HAVING" clause as a Filter

    I have the following query: Select 'CATALOG' AS CatName, f.ProductID AS ParentSku, f.Name AS ParentSkuName, t.ProductID AS ChildSku, t.Name AS ChildSkuName, t.DisplayInd, t.oid AS ChildID, f.oid AS ParentID, getdate() AS DateGenerated, a.Name FROM [CATALOG_CatalogRelationships] a INNER JOIN...
  4. RogueSuit

    SQL - Counting through a returned dataset

    I have the following query: Select 'TEST' AS CatName, f.ProductID AS ParentSku, f.Name AS PrntSkuNm, t.ProductID AS ChildSku, t.Name AS ChlSkuNm, t.DisplayInd, t.oid AS ChildID, f.oid AS ParentID, getdate() AS DateGenerated, a.Name FROM [TEST_CatalogRelationships] a INNER JOIN...
  5. RogueSuit

    Cannot push data from DTS to Access

    I created a Stored Proc, which pulls data into a temp (named - #temp) table and then selects “all” from the #temp table. All of the data is returned as it should and the proc “runs” as it should – no exceptions or errors. I then create a DTS package with a connection From SQL and a connection...
  6. RogueSuit

    Using DTS w/stored procedures - posting results to an Access database

    I created a cursor named CrossReport and a DTS package that has 3 elements 1.Standard connection to a data source 2. Transform Data Task 3. Connection to an Access Database On the Transform Data Task “TDT” I used SQL query and used the statement – EXEC CrossReport. I then preview the data -...
  7. RogueSuit

    DTS and SQL2000 - for producing reports

    DTS and SQL2000 - for producing reports I am using SQL Enterprise Manager to create a DTS package so that I can take data from several tables then post the data I choose to an excel spreadsheet. That part is pretty simplistic – here’s where it gets confusing (for me): I have 2 tables: 1...

Part and Inventory Search

Back
Top