T-SQL | Lightweight Implementation to Enable Built

I have an SSIS data flow that contains a script Component as a source. I'd like to generate the source data by running a script on an SQL Server database. The connection string to be used to connect to the database is set to be sensitive. How can I read this sensitive parameter inside the script component using C#?

In a Script Task, usually it is read for example as the following:

...

I am struggling to get this code to work, not sure how to do it in PL/SQL like T-SQL, ive tried both:

...

I am new to Transact-SQL, assume I have a sql table

...

I distinctly recall that T-SQL will never let you mix LAG and WHERE. For example,

...

I can not imagine how to fix my problem using t-sql.

• I need MIN(ValidFrom) and MAX(ValidTo) out of a table with different time blocks considering a chronological sequence and a number.
• A normal group won't work because MIN(ValidFrom) and MAX(ValidTo) for num 100 will not be correct.
• I can not imagine how to get the expected results from this table using any analytic or rank function in t-sql.

I need minimum and maximum dates out of the following table.

ValidFrom ValidTo Num ID Number 2019-06-01 2019-12-31 100 01234567 2020-01-01 2020-03-31 100 01234567 2020-04-01 2020-12-31 100 01234567 2021-01-01 2021-01-31 100 01234567 2021-02-01 2021-03-31 50 01234567 2021-04-01 2021-09-30 50 01234567 2021-10-01 2021-12-31 50 01234567 2022-01-01 2022-04-30 100 01234567

Expected result of the query:

ValidFrom ValidTo Num ID Number 2019-06-01 2021-01-31 100 01234567 2021-02-01 2021-12-31 50 01234567 2022-01-01 2022-04-30 100 01234567 ...

How can I (or is it possible?) use something like CASE statement in T-SQL inside QUERY in Google spreadsheet?

I want to do something like this:

=QUERY(A6:AI,"select A,(CASE WHEN D>2.5 THEN 'Yes' ELSE 'No' END),E,C,J")

I want basically a custom column with Yes/No values based on other column. Is it possible?

EDIT: To better explain, I have data in table Existing table and I would like to transform it to the Transformed table using QUERY statement:

So I need something to say: if column D is empty, print No, otherwise print Yes. This has to be in the QUERY because it's not the last column, there will be more data after column Finished. So I have this:

=QUERY(A4:D,"Select A, B, (CASE WHEN D='' THEN 'No' ELSE 'Yes' END)") - But that doesn't work

Thank you for help,

...

My current T-SQL query provides the following results:

Query:

...

While converting some Access queries to T-SQL, I came across the Access function IIf. I read the documentation here and understand it takes 3 parameters: the expression, the if true, and the if false. What I have yet to find is if the "false" param is required? And if a false is not provided, what is the behavior?

UPDATE: When this question was asked, I did not know if the query worked with only 2 parameters (b/c I can not run the query in Access). I did, however, suspect it might work (with only 2 params) b/c a few queries I am converting (to T-SQL) have nested IIF's and the last IIF has only 2 params.

...

I'm trying to create a procedure that will:

• take any number as an input e.g. 102
• find the sequence range it belongs e.g. 100 to 103
• return a suggested next number to the user e.g. 104

The table itself will look something like this:

Num 100 101 102 103 110 111 112 113 114 115 120 121

Ideally the output of the query would return something like this:

start end nextNr 100 103 104 110 115 116 120 121 122

I this what I'm trying to do is linked to some kind of Gap and Island technique. I had a look at trying something from here but couldn't quite get it to work. Gaps and Islands Link

This is what I tried coming up with...

...