Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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