Until SQL supports a true Boolean data type, bit is the best alternative.

* Why would I reserve 2 bytes for a...

Jeff Moden (5/23/2012)

The day that I want is really the end of the previous month which is always 1 day less the 1st of the month. So I just...

Consider adding a computed column to your CustomerMaster table to produce the domain name. If you can't update the structure, then you can use a CROSS APPLY to make...

Wikipedia disagrees with you

Row (database)

---

In the context of a relational database, a...

Consider using a reporting tool, such as SSRS, to write your reports. Otherwise the crosstab/pivot already recommended is your best approach.

Drew

Brandie Tarvin (5/17/2012)

---

Drew, how does that prevent NULL from overriding...

This doesn't produce the same results as the original queries. Specifically, when there is...

I prefer this to prevent NULL values.

DECLARE @L_ZERO INT = 0

SELECT @L_ZERO = IdMyTable FROM MyTable WHERE ColumnRef = 1000

Drew

You have a couple of options depending on what you want. As Lynn is trying to point out you have an implicit CROSS JOIN, so you can make it...

The problem is here:

from GLDEFRLS

INNER JOIN accropts AC

ON AC.AccAccrOption = EM.EacAccrOption

INNER JOIN empaccr...

anthony.green (5/17/2012)

---

This should do the trick, also dont forget the power of Google or your favourite search engine

set datefirst 1

DECLARE @dt DATETIME, @WeekOfMonth TINYINT

SET @dt = '2007-07-08'

SET @WeekOfMonth = DATEDIFF(week,...

Sean Lange (5/16/2012)

---

It was a 2 minute brief example of using exists to demonstrate the task at hand. I certainly was not expecting a code review. 😀

Your points are all...

If your collation is case-insensitive (default ), you don't need to specify both A-Z and a-z.

Drew

Sean Lange (5/16/2012)

---

Here is a simple example using exists to accomplish the type of behavior you are describing.

alter proc MyProc

(

@SomethingElse int

)

as begin

select top 5 * from sys.sysobjects as Something

if exists(select...

You might also want to add the CASE statement as a computed column on your PART table and create an index on that computed column.

Drew