Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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