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!

  • Congratulations strongm 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: willydude
  • Order by date
  1. willydude

    Moving a DB.

    As to the saving of stored procedures issue, they would not save b/c they are "Alters", not "Creates." They were being "re-introduced" to the DB. DUH! I still am very curious about where my DB files are saved. Sorry and thanks, Bill
  2. willydude

    Moving a DB.

    I dragged and dropped everything (obviously not everything) that I saw that was related to SQL. Where specifically is a user created DB stored? Also, how/where do I store my stored procedures that I create. F5 runs them, but when I go to save the sproc, I get directed to "MyDocuments\SQL...
  3. willydude

    Moving a DB.

    I copied my Payroll DB project to a flash drive. I believe the Payroll.mdf file should be in: “F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data”, but there is nothing after \Data. I did a search on the F: drive for *.mdf and found the Northwind, Pubs, master, msdbdata and many other files, but no...
  4. willydude

    Which columns to cluster?

    I have the following tables. Note CustNumber out of order in first table and Cust_PK_ID in second table. Tbl_Customers Cust_PK_ID CustNumber Name 1 36 Pete 2 38 Millie 3 12 Coop 4 3 Andy Tbl_Jobs Jobs_PK_ID Cust_PK_ID...
  5. willydude

    Reinstall problems. Finding server.

    John, I got it to work. After doing some searching and reading of posts on different sites, I found that: 1)I needed to remove the current Native Client program. 2)D/L and run the file ‘sqlncli.msi' from MS. It saved itself to the correct directory. 3)Re-run the SQL Express setup. I lost all...
  6. willydude

    Reinstall problems. Finding server.

    John, Thanks for the reply. I came to the conclusion that I did not actually have the program installed. I do have SSManagement installed, but not the SQL Server itself. After installing, reinstalling and maxing out with frustration, I am at a loss. I have gone through the whole process five...
  7. willydude

    Reinstall problems. Finding server.

    Over the weekend my PC died and I had to reinstall everything. When re-installing SQL Server 2005 Express and Management Studio, I have encountered some problems. I do not recall having any major issues when I installed it over a year ago. I did save a lot of my work on a flash drive. Hopefully...
  8. willydude

    TRY/CATCH. What if record does not exist?

    GM, I think I was confusing a SQL error with my @Message error of "Batch Number Does Not Exist." SQL won't throw an error if there is no batch number. Correct? Thanks. Bill
  9. willydude

    TRY/CATCH. What if record does not exist?

    I’m trying to use the TRY/CATCH method when deleteing a record. If the record exists, it works. But if the record does not exist? The following doesn’t tell me that the record does not exist and I do not receive any error message. Please note the attempt with the IF/ELSE. BEGIN TRY BEGIN...
  10. willydude

    No error if target record does not exists.

    Everything I’ve seen so far re: errors, has to do with inserting data, not deleting. With a valid code (A), I get my @Message ‘Record Deleted.’ which makes sense given where the @Message is located. Even though no record will be actually deleted due to a constraint issue. But it does not give...
  11. willydude

    No error if target record does not exists.

    I have created the following delete sproc. If the target record exists, it is deleted. But I am not getting any error msg if the target record does not exist. Use ClientPayroll GO set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[Clients_Delete_ClientWorkStatusInfo]...
  12. willydude

    Saved sprocs not going where I need them.

    So when I press F5, the sproc is saved in my Payroll DB and I do not need to use File/Save which saves it to the Projects folder? I've been doing way too much clicking and saving! Thanks.
  13. willydude

    Saved sprocs not going where I need them.

    After making changes to sprocs in my DB “Payroll” and then saving them, I am directed to: C:\Documents and Settings\Administrator\My Documents\SQL Server Management Studio Express\Projects where the sproc and the changes are saved. But when I go back into the sproc in the Payroll DB, the...
  14. willydude

    Use of EXISTS when data required?

    Boris, thanks for the help. I don’t believe I explained the situation well enough. Let me give a “real life” example. I have the following tables; tblClients: contains Dennis and Bob. tblJobSteps: contains many non-time studied jobs and one time studied job (199-9381-21). All job step...
  15. willydude

    Use of EXISTS when data required?

    All of the variables below, @Client_PK_ID, @FundingCode, etc. are required EXCEPT for @TimeStudyPercent. A client might have one, but then again, they might not, which is OK too. If they have one, I need to pull their percent from the tbl_Clients_ClientTimeStudy. If they do not have one, then...
  16. willydude

    Numeric to varchar issue

    Boris and Denny, Thanks for the help. I'm using the following: print 'Prevailing ' + Convert(varchar (10), ISNULL(@PrevailingWage,0)) Is there a performance difference with any of these? Thanks, Bill
  17. willydude

    Info from 2 unrelated tables into one with error msg.

    Thanks HMC, --following works as desired SELECT @Client_PK_ID = Client_PK_ID FROM tbl_Clients_ClientBasicInfo WHERE tbl_Clients_ClientBasicInfo.ClientNumber = @ClientNumber --This works also. I have more columns to add here. SELECT @StepNumber_PK_ID = StepNumber_PK_ID, @PayFormulaCode =...
  18. willydude

    VB Script with an Input box?

    XWB, Sorry it took so long for me to get back. Below is my final code. It does what I need. Thanks for the help. Bill Dim Fso, FromWimPC, FileDate FileDate = InputBox("Enter the first work date of the week.") Set Fso = CreateObject("Scripting.FileSystemObject") Set FromWimPC =...
  19. willydude

    Numeric to varchar issue

    Well, I am not getting an error msg for the Print statements, they are just not printing. At a minimum, I believe that I should be getting the: 'Prevailing ' part to print, but it's not. It should read: 'Prevailing 7.25' I have other Print statements in the same sproc that are working...

Part and Inventory Search

Back
Top