case Statement with Cte

Question

case Statement with Cte

jagjitsingh

Ten Centuries

Points: 1059
More actions
December 17, 2021 at 8:07 am

#3964687

Hi
I am getting data from Cte
I want if @ICode parameter is not null then select statement should execute with parameter else all data
SELECT * from cteCab where icode = @ICode
else select * from ctetab

Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246693 More actions · Answer 1

I answered this question yesterday. Why are you asking it again?

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Jeff Moden SSC Guru Points: 1003861 More actions · Answer 2

@jagjitsingh,

When I run into problems like the one's you're having, I go back to the basics.

The first step is to get out of the dynamic SQL world and get some regular code to work properly first. Then, you can work on making it dynamic and you'll be much more successful.

In fact... I lied a bit. I don't run into problems like the one's you're having because I always start with working code first. Then I convert it to dynamic SQL one parameter at a time.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

MMartin1 One Orange Chip Points: 27764 More actions · Answer 3

Seems like this user is posting exam questions on the forum.

----------------------------------------------------