I know some of you pretend like you already have some knowledge, when you don't. You act or talk in a conversation like you understand what is being discussed. Then...

Jeff Moden (11/6/2016)

---

To be honest, I'm starting to get really pissed off at people and their "new improved shinny bobbles". I've spent countless hours listening patiently and doing due...

quinn.jay (11/6/2016)

---

Hello, I have Google and Amazon searched foe books and training materials for SQL Server SSAS Tabular, and I find 2012 SSAS Tabular, and pre-order for 2017 materials. Is...

Which SQL Server version(s) and edition(s) are you using?

😎

There is a flaw in your logic as only if "John" == "Linda" will it ever return anything, which is not going to happen.

😎

When searching for multiple values in a...

Looks like the virtual windows machine is using NAT/ Shared Network, probably easiest to change that to Bridged Network.

😎

Overheard conversation at a "database" conference:

a: That guy must be an Oracle DBA!

b: Why on earth do you think that?

a: Watch him, he doesn't bring anything to the table!

😎

Enjoy mate!

😎

And more to come...

There are three ways of doing this, using the describe_first_result_set system functions or procedures, use FMTONLY (deprecated) or OPENROWSET, the last one requiring the "Ad Hoc Distributed Queries" configuration to...

sjaco1 (11/5/2016)

---

Hi,

can anyone confirm to have the same issue with the latest version of SSMS

since I installed it yesterday I am not able to edit / configure Job steps ...

Question, aren't you missing the classroom table? Would have thought that the solution should have classroom provisioning.

😎

The Hunter

Suggest using the import wizard then

😎

I...

Here is an alternative to Luis's fine solution

😎

USE TEEST;

GO

SET NOCOUNT ON;

Declare @UserGroup nvarchar(MAX);

SET @UserGroup = 'UserGroup1|User1|User2|User3&UserGroup2|user4|user5|user6&Usergroup3|user7|user8|user9';

;WITH BASE_DATA AS

(

selecT

DX01.ItemNumber AS X1

,DX02.ItemNumber AS...