Search results for query: *

I honestly don't know. I can open my installer schedule just fine, when I try to open Templ/Inst or just Templ is when I receive the errors. I was told to look for a temp or inst that has a null date, "Query would look something like this: Select * From Events where Event...

Good morning. I am trying to set a field operations schedule that's tied to our SQLServer and when I refresh the schedule I am receiving an error "Error: Cast from type 'DBNull' to type 'Date' is not valid", I have a bunch of jobs that have disappeared off of today's schedule as if they've...

That probably would have helped. Below is the error and I've attached a screenshot if that helps. Msg 2627, Level 14, State 1, Line 1 Violation of PRIMARY KEY constraint 'PK_ScorecardSalesGoals_1'. Cannot insert duplicate key in object 'dbo.ScorecardSalesGoals'. The statement has been...

Yes, I would assume that the HMS is the sales rep. All of our employees go by a 3 digit code in our system. For example, I tried: 'TMO','2013-6-01',90000.00 and received an error.

Hello and good morning. I am VERY new to this whole SQL thing. I am trying to update a monthly sales scorecard in SQL, I have the scorecard insert opened up in SQL, as well as the info that needs to go on it however I am stumped when it comes to updating it. This is the text on the scorecard...