Float

Well then we're arguing about two different things 🙂

The salary ranges and process for raises should be transparent if they aren't that would be huge red flag to flee that...

fhanlon (6/5/2015)

---

I did acknowledge that some companies give raises based on merit. I worked for one place that evaluated everyone each year and said that based on performance you...

briancampbellmcad (6/5/2015)

---

Yes thanks for the tips on several points... I got the same results so my initial query wasn't that bad... but I did discover that the data in general...

fhanlon (6/5/2015)

---

I think the idea of publishing salaries is great. If a company wants to be dishonest and pay 2 people with the same experience and seniority doing ...

That sample data returns 7 rows(and the table name on the second insert section is wrong) with the query you posted earlier.

SELECT c.PeopleID

FROM [certs] c

where c.[statusID] = 1 and...

Your subquery isn't related to your main query in any way, so if it returns any record it will remove all results from the final result.

With just the primary keys specified it is...

Just wondering if I'm reading your various constraints right but you say you want a 1 to M relationship between PoNum and VIN, but that doesn't look possible. Did...

dwilliscp (6/4/2015)

---

Lynn... it looks like you can not use a case statement inside of the update statement... just trying to make sure.. I guess I can put the update together...

Just out of curiousity how would a file name ever have a \ at the end of it, wouldn't that make it a directory?

Hmm... that would be interesting to test but I'd imagine the overhead of doing the except, staging those results, then running the resulting update would be greater than just running...

Unless real time updates to the view are needed could you just run a scheduled job every however often to populate your temp table instead of using triggers?

What exactly are you trying to convert to a case statement? You wouldn't put a goto or any control flow for that matter in a case statement.

It sounds like you just explained it, users are deleting records or the application is trying to write a record and deciding to roll back the record, either directly in...