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

    Truncate not working

    Do you have any constraints on the table? Krickles | 1.6180
  2. Krickles

    Schedule a command line task

    ...of course, I finally find the answer on the MS site after posting on TT.[blush] In case you are interested: http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/schtasks.mspx Krickles | 1.6180
  3. Krickles

    Schedule a command line task

    The search feature is down so please forgive me if this has been asked & answered. Anyway... How can I schedule a command line task with the XP scheduler? If not with the scheduler, is there another way? Thanks in advance, Krickles | 1.6180
  4. Krickles

    SQL server

    You can try something like SELECT PartNumb, Descp, Price FROM tablename WHERE len(Descp)>1 and use the query in the transform data task properties SQL query window. BTW, I'm assuming Descp = description. Krickles | 1.6180
  5. Krickles

    Stored Procedure uses 100% CPU

    Actually, you can purchase a 3rd party A/C and have it installed...aftermarket car parts. Sorry you didn't care for the example. Obviously my point about repairing the sproc isn't the answer you wanted. Krickles | 1.6180
  6. Krickles

    buy sql server software

    I goofed by assuming since IIS was needed, first would be the upgrade then the SQL Server install. Krickles | 1.6180
  7. Krickles

    buy sql server software

    For IIS you will need to upgrade to XP Pro. Concerning SQL Server, you can purchase the developer edition if you are trying to learn SQL Server or are (obviously) developing. For production it's a different story requiring much more detail. Krickles | 1.6180
  8. Krickles

    Stored Procedure uses 100% CPU

    You can control the amount of resources an instance of SQL Server claims in SQL Server Properties: EM --> Tools --> SQL Server Configuration Properties As far as I know you can't do this per sproc. I maintain, if the problem is with the sproc, repair it before you move forward. Paradigm...
  9. Krickles

    How to Convert this Query in to Cross-Tab?

    Yes, it can be done. Check the following FAQs: faq183-5269 faq183-5278 and threads: thread183-451930 thread183-872564 Krickles | 1.6180
  10. Krickles

    Stored Procedure uses 100% CPU

    Instead of trying to limit the resources (which is an option), why not correct the sproc? It sounds like you have a Cartesian product. Start troubleshooting by looking at the joins and by examining the execution path in Query Analyzer. If you haven't looked at the execution path before, do...
  11. Krickles

    Using SQL Views in Crystal

    Do you mean in CRs or actually in the SQL query? Krickles | 1.6180
  12. Krickles

    2005 !

    Please don't take this as an insult, but did you download the express edition? If so, it doesn't have developer or admin tools (yet). Krickles | 1.6180
  13. Krickles

    help with a sql statement

    Try something like: SELECT CASE WHEN fund_code = 56 THEN SUM(tranbase) fund_56 Else 0 CASE WHEN fund_code = 07 THEN SUM(tranbase) fund_07 Else 0 . . . FROM table Let me know if this gets close and we can tweak from there. Krickles | 1.6180
  14. Krickles

    Cannot insert the value NULL into column

    Open Enterprise Manager --> Databases --> Open your database --> Right click on table name --> Choose Design Left click on the ID field. It should be either numeric or int. At the bottom left under Columns, Identity should be Yes. I hope this helps. Krickles | 1.6180
  15. Krickles

    Links not working in e-mail

    Have you tried holding CTRL + mouse click? Krickles | 1.6180
  16. Krickles

    Inserting records certain criteria

    If the missing data is actually a blank space try: INSERT INTO tracking_details (emp_id, ref_id, dept, start_date) SELECT emp_id, ref_id, CASE WHEN class1 <> '' and class2 = '' THEN 'SC' ELSE 'PT' END, getdate() FROM emp_details If the missing data is actually NULL try...
  17. Krickles

    DTS from Excel spreadsheet does not bring decimals forward correctly`

    Is the number in the Excel file an entered value (keyed directly) or a derived value (e.g., from a formula)? Krickles | 1.6180
  18. Krickles

    Database Aliases

    TJRTech & ESquared: I was talking to someone else about dynamically naming the database and he suggested trying something like DECLARE @dbn varchar(50), @dbname varchar(200) SELECT @dbn = (SELECT db_name()) SELECT @dbname = ('SELECT [fieldname] FROM ' + @dbn + '.dbo.[tablename]') EXEC @dbname...
  19. Krickles

    Return Database Name?

    You want to dynamically call the db based on the db properties? As far as I know this can't be done directly. However, you can try using CASE statements...depending on how many actions you are performing this can get verbose. Sample: SELECT fieldname1, fieldname2, ..., fieldnameN, CASE WHEN...
  20. Krickles

    Date-specific query won't work

    It seems your smalldatetime field must contain time entries other than midnight (00:00:00). If so, your best bet is to use the BETWEEN clause:WHERE [date] BETWEEN '2004-07-15 00:00:00' AND '2004-07-15 23:59:59' Krickles | 1.6180

Part and Inventory Search

Back
Top