Shawn

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,814 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

9,673 reads

Blogs

Creating a New Sequence–#SQLNewBlogger

By

I wrote about sequences in an editorial recently and decided to start using them....

An All Star Lineup for EightKB

By

An online conference is coming on June 17, 2020 that is full of high...

How should I store currency values in SQL Server?

By

On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...

Read the latest Blogs

Forums

Explanation of Page Splits

By stevec883

Q1 -- I have read quite a few articles on page splits and am...

(duplicate)

By stevec883

(sorry, this was a duplicate)

Script error

By sizal0234

I am trying to monitor the sql services on couple of instances and found...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers