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 Rhinorhino 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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]...
  6. 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...
  7. 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...
  8. willydude

    Numeric to varchar issue

    I am having a very trying time trying to get a print statement to work with a conversion. I have verifed that when the query is run, there is data in the @PrevailingWage parameter. None of the following have worked. What am I missing? print 'Prevailing ' + Convert(varchar (10)...
  9. willydude

    Info from 2 unrelated tables into one with error msg.

    I am entering info into a timesheet table. The Client_PK_ID comes from the ClientBasicInfo table; the StepNumber_PK_ID and other info comes from the Jobs_JobSteps table. All the info gets inserted into the Timesheet table. Pretty basic idea. I have the following Select statements. SELECT...
  10. willydude

    VB Script with an Input box?

    I was able to get the following code to work and copy the file(s). I used the same code with different icons (and file names) for a number of different files to move. Here’s the code used: Dim Fso, FromWimPC Set Fso = CreateObject("Scripting.FileSystemObject") Set FromWimPC =...
  11. willydude

    Bad Logic in IF statements?

    By using PRINT, I have verifed that values are going into the variables. The variables and their values are: @PrevailingWage 1.00 --PW. Values from 1.00 to 12.00 tested. @StateMinimumWage 6.65 --SM @FederalMinimumWage 5.85 --FM User enters the PW value during data entry. sproc pulls...
  12. willydude

    Can an IF be used with CASE?

    I get “incorrect syntax” error msg’s with the following. In actual use, if one of the following (AW, PR, TS, SW, RW or GS) is not entered as the StepCode, then error msg. For brevity's sake, not all have been listed below for Case selection example. --Beginning the use of CASE statements...
  13. willydude

    Desktop Icons with VB Script

    I am trying to add some desktop icons for a WIN98 PC. Each of these would be used to copy an individual file to a network folder, where I could then access the file from a different PC. I have tried the code below but keep getting an error message with the following info: Error message: Line...
  14. willydude

    Code not catching string length problem

    The following bits of code are allowing too long of strings to be entered. The entries are being truncated before going into the table and will go into the table, but only if the trucated value is correct. (i.e. 1211 is too long, but is truncated to 12 which is legitimate.) Any way it’s looked...
  15. willydude

    Foreign Key issue in SPROC.

    I am using SQL Server Express 2005. I have verifed that a valid record with a JobNumber_PK_ID does exist in my JobNumber table and am able to properly enter info through the table, but I keep getting the classic message below when running the sproc. Msg 547, Level 16, State 0, Procedure...
  16. willydude

    Pentium I or II

    Could someone tell me, based on the following info, if my processor is a Pent I or II. I was wanting to purchase the HP7310 printer to use with this pc, but the recommendations are for the PII. TIA, Bill System Manufacturer IBM System Model 6565B7U System Type X86-based PC Processor x86 Family...
  17. willydude

    Input box run around

    If the user selects OK or cancel, then quit. This works. If the user enters something, then continue the process. This does not work. If I enter info, it wants to quit. It should not. I have tried numerous ways with no complete success. Static Sub MonthAndYear() 'remember to >>Public...
  18. willydude

    Deleting sheets not working

    This is the kind of problem that drives me crazy. The following works. It deletes all sheets that have the name sheet. Sub DeleteWorksheets() Application.ScreenUpdating = False Application.DisplayAlerts = False Dim sheet As Worksheet For Each sheet In ActiveWorkbook.Worksheets If InStr(1...
  19. willydude

    Wrong # arguments or invalid property assignment

    Wsheet is the activesheet name. SalesPeople is the sheet that has the salespeople's names. I want to name a cell on the active sheet (i.e Branch8) _ using the activesheet's name and the salespersons _ name from the worksheet "SalesPeople". Example: "JoeBranch8" None of the following...
  20. willydude

    Concatenating sheet name with string

    I am trying to concatenate a string with the activesheet name to name a range (cell). This cells value from each individual sheet will then be copied to a summary sheet. So if salesperson Joe has commissions on sheets Branch1, Branch2 and Branch3, the cell names for Joe’s commissions on these...

Part and Inventory Search

Back
Top