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,861 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,510 reads

Blogs

Top 10 Must-Ask Questions Before Going to the Cloud

By

After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top...

Markdown Links– Remembering the Basics

By

For some reason, I can never remember how to do markdown links. I know...

Why Aren’t You Automating Database Deployments?

By

Building out processes and mechanisms for automated code deployments and testing can be quite...

Read the latest Blogs

Forums

Tìm hi?u v? ngo?i h?i Forex ? Vi?t Nam

By duyen96dn

th? ph?n ngo?i h?i t? lâu dã v?ng m?nh m?nh m? trên toàn c?u....

error while running Replication

By atulyan.aries

Has anyone faced this error Agent message code 20037. The process could not bulk...

Run Azure Automation Runbook Against DB Hosted on an Azure VM

By dan-404057

Hi - has anyone created a PowerShell runbook which connects to a database hosted...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers