Back to OIM Explorer

dbo.QBM_FTParameter1AsInClause

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 557 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL20 lines
1CREATE FUNCTION dbo.QBM_FTParameter1AsInClause(2  @ValuesIn dbo.QBM_YParameterList READONLY3) RETURNS TABLE4  WITH SCHEMABINDING5AS6RETURN(7SELECT8  CONCAT('(''', string_agg(convert(nvarchar(max), CASE9  WHEN x.Parameter1 LIKE '%''%' THEN10  replace(x.Parameter1, '''', '''''')11ELSE x.Parameter112END), N ''','''), ''')') AS CollectedLine13FROM(14SELECT15  c.Parameter1, ntile((16SELECT 1 + count(*) /(4000 /(max(len(v.Parameter1)) + 3))17FROM @ValuesIn v)) over(18ORDER BY c.Parameter1) AS Gruppennummer19FROM @ValuesIn c) AS x20GROUP BY x.Gruppennummer)
Open raw exported source
SQL ยท Raw5 lines
1create function dbo.QBM_FTParameter1AsInClause (@ValuesIn dbo.QBM_YParameterList readOnly ) returns table with SCHEMABINDING as return(   select concat2('(''' ,string_agg(convert(nvarchar(max) ,case when x.Parameter1 like '%''%' then replace(x.Parameter1, '''', '''''') else x.Parameter1 end )  , N''','''3 ) , ''')' ) as CollectedLine from ( select c.Parameter1, ntile(( select 1 + count(*) / (4000 / ( max(len(v.Parameter1)) + 3)) from @ValuesIn v )) over4 ( order by c.Parameter1) as Gruppennummer from @ValuesIn c ) as x group by x.Gruppennummer ) 5