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
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...
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...
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...
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...
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...
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
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...
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...
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]...
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.
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...
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...
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...
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
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 =...
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 =...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.