reduce number of rows by joining rows based on id and category
The data I have is below format : Data I want in the final table: Not sure how to do this one.
Tag: tsql
To check whether the table exists or not dynamically
DECLARE @DROP VARCHAR(MAX) DECLARE @TAB VARCHAR(MAX)=’Employees’ DECLARE @CREATE VARCHAR(MAX) DECLARE @SELECT VARCHAR(MAX) –IF OBJECT_ID(‘DBO.’[email protected],’U’) IS NOT NULL –BEGIN IF (EXISTS (SELECT 1 …
How to pass an array into a SQL Server stored procedure
How to pass an array into a SQL Server stored procedure? For example, I have a list of employees. I want to use this list as a table and join it with another table. But the list of employees should …