There's no way to return a resultset and set variables using a single SELECT statement. But there's one way to do it using a MERGE statement. It's quite simple, you first declare a variable table which will be used to store some data. You then use a...

There's no way to return a resultset and set variables using a single SELECT statement. But there's one way to do it using a MERGE statement. It's quite simple, you first declare a variable table which will be used to store some data. You then use a...

There's no way to return a resultset and set variables using a single SELECT statement. But there's one way to do it using a MERGE statement. It's quite simple, you first declare a variable table which will be used to store some data. You then use a...

There's no way to return a resultset and set variables using a single SELECT statement. But there's one way to do it using a MERGE statement. It's quite simple, you first declare a variable table which will be used to store some data. You then use a...

...

...

How to change the length of a column defined with a Primary key constraint?...

How to change the length of a column defined with a Primary key constraint?...

When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when you use the “Deploy” option (such as structure changes or aggregation design changes).  This means a lot of sitting around and wa...

When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when you use the “Deploy” option (such as structure changes or aggregation design changes).  This means a lot of sitting around and wa...