PJ_SQL (8/16/2016)

---

Will this help?

CREATE TABLE [dbo].[PP](

[PP_NUMBER] [varchar](10) NOT NULL,

[PP_CAR] [varchar](2) NOT NULL,

[PP_Tran] [varchar](1) NULL,

...

Here is the challenge. I can't see your screen, I have no idea what your...

PJ_SQL (8/16/2016)

---

It is inserting value in PAS table if the conditions matches or else updating values.

But the value for last_update_DT in stored proc is entered manually 08142016

even though when it...

I understand. But still the question remains....how to make what happen? It is...

PJ_SQL (8/16/2016)

---

I have this script below in stored proc. I am manually entering the manual entry before running the stored procedure, those are dates from 2 days before and it...

sqld-_-ba (8/16/2016)

---

I read somewhere SSC has 600K visitors. Assuming 10% see the salary survey, and 1% respond, that is 6000 responses. I'm also trying to advertise this on stackexchange, and...

But useful for what? Unfortunately the membership of SSC is quite...

What are you trying to accomplish with this survey? You are not likely going to get very many responses which makes the data you collect pretty much useless.

festiva_96 (8/15/2016)

---

The error is : "Invalid column name 'NotEligible'"

However, I have managed to solve it by using SET PARSEONLY OFF/ON around the script to turn off the reference checking at...

Wow the spam really is getting bold and stupid. We now have a spammer who added a spam rely to a previous spam from a different spammer. This is quickly...

Ed Wagner (8/12/2016)

---

ChrisM@Work (8/12/2016)

---

Lynn Pettis (8/12/2016)

---

Steve Jones - SSC Editor (8/12/2016)

---

Lynn Pettis (8/11/2016)

---

Having rules for answering questions makes sense but I have to ask the question, Why? Has as...

Thanks Jeff. I was going to roll this into...

Phil Parkin (8/11/2016)

---

Sean Lange (8/11/2016)

---

Ed Wagner (8/11/2016)

---

Steve Jones - SSC Editor (8/11/2016)

---

Minor Update: The plan to replace the forums is proceeding. We've narrowed down to a couple companies, though the...

Ed Wagner (8/11/2016)

---

Steve Jones - SSC Editor (8/11/2016)

---

Minor Update: The plan to replace the forums is proceeding. We've narrowed down to a couple companies, though the upgraded version of this...

Anandkumar-SQL_Developer (8/11/2016)

---

Dear Sean Lange,

Your Query is working awesome . but column names are showing...