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

7,538 reads

Blogs

Beginning T-SQL and Career Roadmap for Women (and Men)! #SQLSatBR

By

Download session materials and watch the recordings of my excellent sessions on Transact-SQL and...

Actual Kubernetes

By

This post continues looking at my process of learning more about Kubernetes. I’ve been...

New product: Azure Data Share

By

A brand new product by Microsoft called Azure Data Share was recently announced. It...

Read the latest Blogs

Forums

How to make in memory SQL transformations within a data flow task

By svenflock

Hi all, first of all, I am new to Integration Services. I googled everything...

CAST FOR XML - Illegal Name Character

By jamie_collins

I am trying to write a query that generates an html report to be...

Get the inactive records in sqlserver

By kbhanu15

HI Team, please help to get the expected data. my Data like below: create...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers