I did a couple of 2000 to 2012 migrations in a current project and it works really good to go by 2008 R2 instance. If you do the restore by...

Tried it once more and sorry, that doesn't work in my project. Doesn't really matter though. I'm going RC0 with it. Rebuilding the project, model and everything from scratch.

Thank...

Did follow your directives exactly. Next time I doubleclick .bim file it opens correctly. I build and deploy, but now I cannot use the analyze in excel function, it says...

I tried like this, but it still shows. Maybe excel has some similar default "connector" for this default measure on that side?

<!--

<Command>

...

I saw that it is fixed now in RC0. Great! :w00t:

https://connect.microsoft.com/SQLServer/feedback/details/712481/-count-of-model-in-tabular-model#tabs

Though my "old" models, created in CTP3 doesn't get "cured" just by being edited in SSDT CTP4 or...

Thank you for the reply. I am not in a position to test all the things atm. I'll try to get back with empiric studies on the matter later on.

Encapsulate the t-SQL code in a stored procedure. Then Execute that procedure in your cmd file.

Create procedure aTestProcedure as

Set nocount on;

<insert your code here>

Then the command you run in...

I got it wrong as well, even though I "cheated" and tried it out before answering 🙂 I didn't have rows in myanothertable and then of course the not null...

Oh. It was for an interview. Well well. 🙂 Hypotethical questions can be interesting for the community as well as I see it. Forums are a great knowledge base of...

Then you might wanna do the if exists check before, to make it more usable outside the sp. Unless you just want to use the view during sp execution, of...

Could you please describe the situation a bit more, to steer the (though interesting) discussion in your way?

If you can't provide real world examples (could be sensitive) but maybe...

This is one classic debate. I tend to lean towards stored procedures heavily. Could be that it creates more DBA work and I like DBA work. 🙂

But it also...

When at a new site, don't assume anything. Not even that they have backups of their important data, run DBCC on the important databases after backing them up. That their...