Use CONCAT and plus:

Declare @val1 varchar(10) = 'abc'
      , @val2 varchar(10) = 'def'
      , @val3 varchar(10) =...

• This reply was modified 6 years, 8 months ago by Jeffrey Williams.

You can rebuild a heap table using ALTER TABLE ... REBUILD;

Also check the amount of space used by your heap tables - I suspect these tables are constantly deleted and...

I don't understand why you drop compression before a load process - can you explain why that is necessary?  I also do not see any advantage to removing constraints -...

I have not had to access MySQL from SSRS - but I have accessed Intersystems Cache, Vertica and other database products.  The requirements are all related to how that products...

Ah, OK. I believe I understand what you're saying now. Before I implement that, though, I've got to mention that one of my coworkers was with me, discussing this...

You are making this much more difficult than it really is...you create the dataset from an expression, you do not include any parameters on the dataset because they are included...

Thank for providing a scenario.  To follow on, a procedure that lives on DatabaseA and references DatabaseA and DatabaseB, which are restored as DatabaseA_20190702 and DatabaseB_20190702, would have a...

It looks like COMPUTE is returning multiple result sets - and ROLLUP and GROUPING SETS will not reproduce those same results.  Either will return a single result set with the...

You can have some interesting things happen to script components that are upgraded to a later version - and then attempted to download to an earlier version.  The version in...

Here is another way: right(cast(@ssn As char(11)), 4)

For SSN - you should either set the column length to CHAR(11) or CHAR(9) and enforce the format...with or without dashes.  That can...

Check how the linked server is setup and configured - there is a problem with the configuration and is not allowing you to connect.

Thanks, DinoRS.  That's kind of what I expected.  I suggested the upgrade-in-place option, since it is a cluster and if things went south we could make the 2012 node...

Click on the Fx button and build your expression - something like this:

="call imb_closure.getCases('" & Parameters!Parameter1.Value & "','" & Parameters!Parameter2.Value & "')"

Add all of the expected parameters in the same...

Build the call as an expression - instead of trying to pass parameters.  Look here: https://stackoverflow.com/questions/16351363/ssrs-mysql-stored-procedure-with-parameters-through-odbc

You are correct - the proxy account would not work for T-SQL agent jobs.