Shawn

Microsoft MVP, PowerShell Enthusiast, major contributor to dbatools PowerShell module.
  • Interests: SQL Server, PowerShell, SSIS/Biml, SSRS

Getting query text from SSMS into a CSV with PowerShell

You have times where you need to copy/paste something out of SSMS' grid view results pane that has a carriage return in it. Trying to copy/paste that data into Excel can be a headache and cause you to waste precious time reformatting. This just offers a tidbit of PowerShell code to help.

3.86 (7)

2018-03-23 (first published: )

5,877 reads

SSRS - Report for Stored Procedure with Multiple Values Passed

You created a report that passed three separate values to a stored procedure, simply enough. However, now the user comes back and they want the ability to select multiple values for the report to return data against. Check out this article for a walk-through on how to handle this request.

4.3 (10)

2014-12-09

10,690 reads

Blogs

Two methods of deployment Azure Data Factory

By

Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes...

Moving the Community Forward

By

Today is the last day that the PASS and SQL Saturday websites will be...

Daily Coping 15 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Who is my customer?

By Kathi Kellenberger

Comments posted to this topic are about the item Who is my customer?

Newbie; Unsure where to Start?

By ptmuldoon

Hi,  First time poster, and hoping everyone goes easy on me. I am very...

DB corruption error 8905, fixed using repair_allow_data_loss ,

By huishi.ca

hi all, I need some help here. Recently, I've found a db with error...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers