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

    Lazywriter warning SQL 6.5

    This should explain what is happening: http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14127
  4. RogueSuit

    URGENT!!!!

    This might provide some light: http://support.microsoft.com/support/kb/articles/Q197/1/76.ASP?LN=EN-US&SD=gn&FR=0&qry=Advanced%20INF%20Installer%20-%20Incorrect%20Setup%20Engine%20Installed&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=SQL Hope this helps...
  5. RogueSuit

    I Want to user the variable table name in the From clause

    You can try setting up a cursor...Something like this: DECLARE ActiveTable CURSOR FOR SELECT TableName FROM TableRoot.dbo.TablesTable WHERE COLUMNPROPERTY( OBJECT_ID('' + TableName + ''),'CreateDate','AllowsNull') IS NOT NULL Then delcare a var: DECLARE @TblNm varchar(6) Open the...
  6. RogueSuit

    Using the "HAVING" clause as a Filter

    I got some interesting results: First, the message window in the query analyzer would display this - Column '[THE COLUMN NAME]' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. ........... [THE COLUMN NAME] = all of the objects...
  7. 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...
  8. 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...
  9. RogueSuit

    Cannot push data from DTS to Access

    Terry thx for the suggestion. I tried that when the localized variable did not work. The globals did not work until I made the adjustments below. You got me thinking about the usage of those variables though....and this is how I fixed it: -I used Global vars (##) -I found that when you build...
  10. 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...
  11. RogueSuit

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

    Thanks Terry - It worked like a charm....!!! I appreciate all of your help.
  12. RogueSuit

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

    Terry: You will have to forgive me - this is my first go @ a "real" SP... could you give me an idea on how the syntax might be laid out – I know that there is a certain way you create a temp table without crushing the resources on the server….but I have never actually done it…..any...
  13. RogueSuit

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

    Below you will find the st proc – also, if you can think of one...is there a better way to wildcard the "like CrossSell____" comparison? I attempted a “*” splat – but it did not work as I though it would. Thx in advance… DECLARE ActiveCatalog CURSOR READ_ONLY FOR SELECT...
  14. 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 -...
  15. RogueSuit

    DTS and SQL2000 - for producing reports

    Thanks Terry....that worked perfectly!
  16. 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