Questions in topic: case-statement - SQL Server Q&A from the SQL Server Central community

Questions in topic: case-statement

votes

answers

113

views

How do you tell a SQL 2008 query to ignore certain rows?

Mar 29 at 07:17 PM Fatherjack ♦♦ 38.8k

case-statement null

votes

answers

146

views

Can you convert datetime to nvarchar inside a case stmt so that you can use sum?

Mar 21 at 06:41 PM sqltiger 130

datetime case-statement sum convert nvarchar

votes

answers

262

views

I am a beginner to sql coding..

Mar 08 at 07:25 PM jacobmat9 40

case-statement

votes

answers

121

views

CASE not giving the required result

Jan 11 at 10:43 AM Fatherjack ♦♦ 38.8k

sql-server-2008 case-statement

votes

answers

268

views

select if statement

Oct 30 '12 at 04:24 PM tombiernacki 318

tsql case-statement

votes

answers

201

views

How can we bring in the detail for invoices that do not have a sales order header using a case statement.

Oct 19 '12 at 10:43 PM JohnM 4.5k

case-statement

votes

answers

318

views

Compare values in SSIS tables

Oct 17 '12 at 08:20 AM mjharper 768

ssis table delete case-statement

votes

answers

329

views

Case statement to populate GL Account for migration script

Sep 29 '12 at 06:44 AM Magnus Ahlkvist 13.7k

migration case-statement

votes

answers

730

views

How do I aggregate employee data by month and day

Sep 13 '12 at 10:05 AM ritu 20

t-sql aggregates case-statement

votes

answers

393

views

CASE STATEMENT USING MULTIPLE COLUMNS

Jul 12 '12 at 08:59 AM Kev Riley ♦♦ 46k

tsql case-statement

votes

answers

400

views

Combining some columns and keeping some single for sums in a select statement

Nov 01 '11 at 01:06 PM Magnus Ahlkvist 13.7k

case-statement sum

votes

answers

586

views

CASE statement

Sep 30 '11 at 06:16 AM sqlnewb 216

oracle case-statement

votes

answers

750

views

CASE WHEN issue with datatypes other than string

Sep 06 '11 at 05:42 PM sqlhungry 76

case-statement

votes

answers

1.1k

views

nested case statement

Aug 17 '11 at 04:58 AM Magnus Ahlkvist 13.7k

t-sql case-statement

votes

answers

468

views

Bringing in Data based on Existance of Data

Jul 30 '11 at 04:50 AM ThomasRushton ♦ 29.2k

sql-server-2005 case-statement null

votes

answers

3.3k

views

Using Case Statement in Where Clause

Apr 20 '11 at 01:06 AM Kev Riley ♦♦ 46k

case-statement conditional case

votes

answers

1.1k

views

Multi Conditional Case Statement

Mar 22 '11 at 01:53 PM siera_gld 936

t-sql case-statement

votes

answers

676

views

Case SUM and Detail

Feb 01 '11 at 06:48 AM Kev Riley ♦♦ 46k

case-statement

votes

answers

4.4k

views

How to use a case statement?

Dec 29 '10 at 03:07 AM ThomasRushton ♦ 29.2k

sql-server-2008 case-statement

votes

answers

574

views

Case Statement Doubles time to render results

Dec 29 '10 at 02:24 AM Fatherjack ♦♦ 38.8k

case-statement views

votes

answers

454

views

Case Statement Assistance

Dec 27 '10 at 02:05 PM Magnus Ahlkvist 13.7k

case-statement conditional

votes

answers

1.3k

views

Pass TSQL query in Else part of case

Dec 21 '10 at 11:27 AM Kev Riley ♦♦ 46k

sql-server-2008 sql case-statement conditional

votes

answers

474

views

case 10 fields for condition if met stops and whole conditon is false

Dec 21 '10 at 10:21 AM Kev Riley ♦♦ 46k

sql-server-2000 case-statement

votes

answers

6.9k

views

Why I can't use CASE statement in WHERE clause

Dec 10 '10 at 06:36 AM Fatherjack ♦♦ 38.8k

sql-server-2008 query case-statement

votes

answers

6.4k

views

SUM(CASE ...) vs. CASE WHEN [field] = 'x' THEN SUM()

Dec 02 '10 at 08:27 AM Mark 2.6k

t-sql case-statement

votes

answers

2.2k

views

Can 'Like' be used in Case Statement??

Oct 27 '10 at 03:01 PM Kev Riley ♦♦ 46k

t-sql case-statement like

votes

answers

882

views

Point of update when using case in an Update statement

Oct 26 '10 at 12:20 PM Kev Riley ♦♦ 46k

t-sql update case-statement

votes

answers

views

case statement is rounding up the hours

Sep 03 '10 at 05:19 AM Fatherjack ♦♦ 38.8k

t-sql case-statement

votes

answers

1.1k

views

how to create a view without using CASE * updated*

Jun 02 '10 at 11:25 AM pete 1 1

sql-server-2000 select aggregates case-statement

votes

answers

397

views

divide by 0 error

May 06 '10 at 11:42 AM Emil Kackos 1

case-statement

votes

answers

926

views

How to find the letter in uppercase and lowercase.

Apr 07 '10 at 06:23 PM sandy 1

case-statement

votes

answers

1.2k

views

sum(case ....) is coming up with wrong answer...need verification

Mar 02 '10 at 10:21 AM graz ♦ 525

t-sql aggregates case-statement

votes

answers

1.4k

views

Problems using case statement in where clause with table valued parameters

Feb 11 '10 at 08:43 PM Jon 2 1

case-statement

votes

answers

1.7k

views

Using CASE and Subselect within WHERE clause

Jan 13 '10 at 09:44 AM Kristen ♦ 2.2k

case-statement

votes

answers

586

views

Update with Case When

Dec 31 '09 at 06:27 PM Ethan 3

case-statement

votes

answers

533

views

Please let me know error in following code

Oct 23 '09 at 09:23 AM graz ♦ 525

sql-server-2008 case-statement

36 questions

67answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags