Breaking News: Grepper is joining You.com. Read the official announcement!

dynamic sql example

Nanu answered on April 27, 2023 Popularity 9/10 Helpfulness 2/10

answer dynamic sql example

dynamic sql example

Comment

ALTER PROCEDURE DynamicSql
    @top NVARCHAR(MAX),
	@attributes NVARCHAR(MAX),
	@table NVARCHAR(MAX),
	@month int
AS
BEGIN
	DECLARE
	@sql NVARCHAR(MAX)
	
	if(@top is not null)
	begin
		SET @sql = N'SELECT ' + @top + '  CASE 
							WHEN ( '+ @attributes +' > 58000 and '+ @attributes +'  < 100000)
								THEN '+ @attributes +' -'+ @attributes +' /10
							WHEN ('+ @attributes +' > 100000) 
								THEN '+ @attributes +' -'+ @attributes +' /20
							else '+ @attributes +'
                        END AS '+ @attributes +'  ' + N'FROM ' + @table ;
	end

	if(@month is not null)
	begin
		set @sql = @sql + N' where month ='+ cast(@month as varchar(max));
	end
	if(@attributes is not null and @month is null and @top is null)
	begin
		set @sql = N'SELECT count(employeeid) as count, ' + @attributes + N' FROM ' + @table + N' group by ' + @attributes ;
		print @sql
	end
	SELECT @sql AS query;
	EXEC sp_executesql @sql;
END
GO

EXEC DynamicSql 'top 6 ','salary ','employee',null

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: dynamic-sql sql

Link to this answer
Share Copy Link

Contributed on Apr 27 2023

Nanu

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

dynamic sql example

Contents

More Related Answers

dynamic sql example

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.