Viewing 15 posts - 976 through 990 (of 1,419 total)
String Split won't work here as you have no delimiter on your strings.
Something to add to the TALLY solutions proposed above is that they miss the cases where there...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 15, 2020 at 6:19 pm
Yet another handy use of a tally table.
drop table if exists dbo.test_TID;
go
create table dbo.test_TID(
TIDPrefix varchar(20) not null);
insert dbo.test_TID(TIDPrefix) values
('A[123xyz]'),
('x[UY345]');
select
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 15, 2020 at 5:34 pm
I've decided to add my name to the list of Steve's around here. My first post on SSC was about 1 year ago. When I signed up I...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 14, 2020 at 5:01 pm
I've decided to add my name to the list of Steve's around here. My first post on SSC was about 1 year ago. When I signed up I wasn't sure...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 14, 2020 at 3:35 pm
Oops wrong thread
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 14, 2020 at 3:31 pm
It could be 2 procs: 1 with mandatory parameter, and 1 without.
No... you recommended using 2 queries. Not two procedures. If you go further up, you'll see that...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 14, 2020 at 12:54 pm
Always good to hear differing methods. Optional parameters are the bane of my life, but that's a reasonable well established method of dealing with it, and fairly low cost...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 14, 2020 at 12:36 pm
Thanks all for your responses,
My question now is Why? Why does not works as is ? we are suggested to a very strict change control policy
Thanks
Why questions are tricky! Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 14, 2020 at 12:28 pm
Also not a good idea... Give this a read: https://www.red-gate.com/simple-talk/sql/t-sql-programming/how-to-confuse-the-sql-server-query-optimizer/
Ha, my recommendation is 2 procs so there's nothing to confuse. If the OP wants to keep dealing with avoidable...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 14, 2020 at 11:41 am
Yup, of course NULL does not equal NULL, but the fldinfo cannot be NULL (confirmed by OP).
So presumably @Parameter is optional and can be NULL. In which case the...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 14, 2020 at 11:15 am
Using
WHERE @parameter IS NULL OR fldinfo = @parameter
You are comparing against a single value
It's not the same query as the one the OP posted. NULL does not equal NULL Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 13, 2020 at 2:29 pm
SELECT *
FROM tblInfo
WHERE @parameter IS NULL OR fldinfo = @parameter
Not quite the same as what the OP posted. Here's another way but readability is not...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 13, 2020 at 11:24 am
Imo it's easier to express as 2 queries
drop table if exists test_tblinfo;
go
create table test_tblinfo(fldinfo int);
go
insert test_tblinfo values (null), (1);
declare
@parameter ...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 12, 2020 at 11:45 am
https://www.sqlservercentral.com/blogs/tally-tables-in-t-sql
declare
@start_yr int=2020,
@years int=20;
;with
tally(n) as
(
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 12, 2020 at 10:16 am
The OP could generate as many years as needed with a tally table 🙂
declare
@start_yr int=2020,
@years...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 11, 2020 at 4:52 pm
Viewing 15 posts - 976 through 990 (of 1,419 total)