My thoughts - a database should be used when you need to have a centralized location for shared data for medium to long term storage for data.  With exceptions.  I...

At times it is really nice because you have the freedom to do the full development from end to end, but at other times it is painful because you start...

Since you are able to get the full name which is half of your battle.  I see multiple approaches to this, none of which are "pretty".

The most supportable approach I...

I agree... Our walls are low, but they still exist.  And in some cases they should exist.  For example, you wouldn't want me mucking around with AD or spinning up...

Quick check online, masks are applied at the table level, not the view level. So to answer question 1 no you cannot use the built-in masking function on a view...

Looks to me like your data source is configured wrong on the report server.  The error (if I am reading it right... I only know english, so I am just...

Looking at that, the temp table is a heap, so unless tempdb is on slow disk OR tempdb is nearly full and your INSERT is causing a lot of auto-grow,...

My opinion - this is a data problem, not something to be solved in your ConStr variable.  I would fix this in the TCondition table as it contains the ">1000"...

@Erland - my mistake.  I had meant "SQL Server Management Studio presents the date in the format that is configured on the server", not SQL Server.  SQL Server stores the...

EDIT - disregard my post.  Everything I said has already been in previous replies.

If memory serves, SQL Server presents the date in the format that is configured on the server. ...

• This reply was modified 4 years ago by Mr. Brian Gale.

Are you trying to install SQL fresh OR is this an upgrade of SQL 2012 to SP3?  Have you had SQL Server 2012 installed on that machine (and potentially the...

again, I would check the result of your print statement and see what is actually being executed and where the error likely is.

Running your query with the exec commented out...

I would start by taking out that "EXEC" line and use the PRINT line to see what is actually being run.  You are comparing OR inserting an NVARCHAR with an...

At my workplace, we actually use SSIS to pull data across from "live" systems into our reporting database.  SOMETIMES it is a 1:1 copy of the data, sometimes we transform...

That is on you to decide if it is a problem or not.  If it is, then you are going to need to come up with another solution.  If it...