October 7, 2015 at 6:03 am
Hello,
who can I use a variable like the followig
set @MAG3 = '<> 0'
or
set @MAG3 = '= 0'
for the following where condition
where patindex('%;' + Mitarbeiter + ';%' , @MAG2) <> 0
I like to change the <> 0 Parameter but
where patindex('%;' + Mitarbeiter + ';%' , @MAG2) @MAG3
don`t work.
Thank for help.
Olaf
October 7, 2015 at 6:10 am
orenk (10/7/2015)
Hello,who can I use a variable like the followig
set @MAG3 = '<> 0'
or
set @MAG3 = '= 0'
for the following where condition
where patindex('%;' + Mitarbeiter + ';%' , @MAG2) <> 0
I like to change the <> 0 Parameter but
where patindex('%;' + Mitarbeiter + ';%' , @MAG2) @MAG3
don`t work.
Thank for help.
Olaf
No, that's not going to work. Can you take a bit of time to explain the logic you are trying to achieve? There will be another way to achieve it, I'm sure.
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.
October 7, 2015 at 6:29 am
Hello,
I have in my select a column called "Mitarbeiter". I like to search for Mitarbeiter in ('SB','MS','BE') or Mitarbeiter not in ('SB','MS','BE')
The 'IN' or 'NOT IN' I want to change via a variable. (For SQL Server Reports)
so I come to the patindex and the change between <>0 and =0
But how to change it?
Olaf
October 7, 2015 at 6:45 am
orenk (10/7/2015)
Hello,I have in my select a column called "Mitarbeiter". I like to search for Mitarbeiter in ('SB','MS','BE') or Mitarbeiter not in ('SB','MS','BE')
The 'IN' or 'NOT IN' I want to change via a variable. (For SQL Server Reports)
so I come to the patindex and the change between <>0 and =0
But how to change it?
Olaf
There's a simple way to do this:
WHERE (@Var3 = 'IN' AND Mitarbeiter IN ('SB','MS','BE'))
OR (@Var3 = 'NOT IN' AND Mitarbeiter NOT IN ('SB','MS','BE'))
It's called a "Catch-all" query and has known limitations. Gail Shaw has a good account of those limitations here[/url].
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 7, 2015 at 6:58 am
That works.
Thanks a lot. :satisfied:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply