If your columns behave as bit columns instead of behaving as int, there's no need for the case, you can simply add the columns.

For instance, there's no reason to use a JOIN if you use fields from one table. Instead of doing this:

SELECT P.PodrobnostiAutoID

FROM dbo.vwPodrobnosti P

LEFT JOIN dbo.vwTableOfGenuss G ON P.GenusAutoID =...

Shift + F6 will go in the opposite order.

There can be a small problem with Jeffem and ColdCoffee's solution.

If you miss an ID value (most common scenario is when you delete a record and the identity does...

It sure was an easy question and a fact anyone using WHERE clauses should know. The difficulty is on understanding the question and reading carefully.

I got it wrong because I...

Thank you Paul and Celko, I appreciate the effort and time you made on answering this going even with more details.

I didn't beleive that DDL would be necessary as the...

This could help you.

DECLARE@nDate1int,

@nDate2int,

@dTodaydatetime

SET@dToday = GETDATE()

SET@nDate1 = DATEPART( y, @dToday)

SET@nDate2 = DATEPART( y, DATEADD( ww, 2, @dToday))

IF @nDate2 < @nDate1

BEGIN

SET @nDate2 = DATEPART( y, CAST( YEAR( @dToday) AS char(4)) +...