MSSQL Question

[Wouter Coinless]

Is there a way to do this:

@FirstId uniqueidentifier = NULL;
@SecondId uniqueidentifier = NULL;

SELECT ..
FROM ..
WHERE
IF(@FirstId IS NOT NULL)
BEGIN
FirstId = @FirstId
END
IF(@SecondId IS NOT NULL)
BEGIN
AND FirstId = @FirstId
END

Or a smarter way? :D Thanks in advance!

[Luc Pattyn]

Hi, this is what I would try:

... WHERE (@FirstId=null OR FirstId=@FirstId) AND (@SecondId =null OR SecondId =@SecondId )

:)

Luc Pattyn

---

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

---

Local announcement (Antwerp region): Lange Wapper? Neen!

---

[Wouter Coinless]

I dont want to include the Ids if they are null.

[J4amieC]

The suggestion given does exactly what you want it to do.