Try this

SELECT

EMPLOYEE_ID

, LAST_NAME

, SALARY

, JOB_ID

, COMMISSION_PCT

...

ScottPletcher (12/12/2014)

---

Emil Bialobrzeski (12/12/2014)

---

ScottPletcher (12/11/2014)

---

SELECT CASE

WHEN @optional_letter = ' ' AND EXISTS(SELECT 1 FROM dbo.Test WHERE letter...

This should do the trick. It validates the Optional letter so it can be either NULL or a letter, checks all the conditions from the first post and makes sure...

ScottPletcher (12/11/2014)

---

SELECT CASE

WHEN @optional_letter = ' ' AND EXISTS(SELECT 1 FROM dbo.Test WHERE letter = @letter AND...

Yes the parameters are from the incoming record while you do an insert

ALTER TABLE Test ADD CONSTRAINT CK_Test CHECK (dbo.CKTest(ID, Letter, Number, OptionalLetter) = 0)

EDIT:

Use the code from my...

Don't be to harsh on me i just done it quickly while doing my other work. In the example below i'm assuming that if the optional letter does not exist...

Hi

Check constraint with user defined function should work as well

i saw lots of people on social sites having problems with:

most of the answers was 1. So saying Simple may apply differently to others :hehe:

Don't think there is any need to give someone sysadmin just to automate few reports in SSIS.

Go with what Phil is saying.

In the previous company i worked for we had a team of database developers and a team of software developers, both groups were assigned to a sysadmin role... Once in...

Without reading their terms and conditions I would say give it a go, if they have some sort of security in place that only mean you won't be able to...

cbrammer1219 (12/9/2014)

---

Ok I have a fairly straight forward question, wondering if anyone knows the answer. I have been tasked to use USPS Address tools to validate our clients addresses, we...

Combination of this

http://msdn.microsoft.com/en-us/library/ms188383.aspx

and this

http://msdn.microsoft.com/en-us/library/ms186819.aspx

Should do the trick

Hi,

The best thing you can provide is the create script for the table itself (including indexes) and possibly stored procedure that you have problems with. Maybe triggers if any.

Hi Jeff,

In my first post on this topic i...