TY for the response, In the recent code we are selecting data form temp table where DOC NOT IN (select DOC from table where code<> -1)

This is what the same...

Okay.

Here is the thing.

The data looks like from emp1,emp2 and emp3 as

DOM1000108806-00110

Here DOM is constant - this will not change

before hifen the data belongs to emp1

next 3 digits hifen the...

Yes,This is UDF. I want to use this function in my stored procedure.

FUNCTION dbo.Blabla

(

@DE1 Varchar(100),

@DE2 Varchar(100)

)

RETURNS TABLE

AS

RETURN

(

SELECT

substring(CAST(COL1 AS VARCHAR(20)),1,CAST(CHARINDEX('-',COL1) AS VARCHAR(20)) -1) AS...

Ya,That's what i am concerned like how to implement it.

Using SSIS variable how to get insertion count?

I completely agree.This is very horrible code. which was written by old people.

Even I wonder after seeing this code..

Wonderful,TY So much.

Yes, I see here. I have a condition I just dragged my table on to dimemsion area by default under hierarchy a column is assigned from my table and operator...

Hello,

As you say I created a tabular model in SSDT and deployed to SSAS. Now in report builder...

If you have any idea on adhoc reporting please share with me.

Here are my questions -

1) End users can create their own reports on the fly using some predefined elements...

OK, I processed the table as well as cube as you say. May I know the syntax for tabular cube to see the data.

is it starts with evaluate or select?

For...

This is where I got stuck.

How to process the tabular cube first? IS there any thing we have to do in SSMS?

Yeah,TY but what am I looking here is..

We have a report model when we upgrade this newer version as background research we decided that its deprecated no longer supported in...

I am trying to Create a Adhoc POC using Tabular Semantic models ( SSAS)

POC is nothing but proof of concept am I right? I mean what are the steps should...

Thank you for the response..

But didn't understood this point "Excel Pivot Tables is a common tool that most users will have that can connect to it. "

Can you please briefly...

Where I have to search for sql extended events or trace in management studio?

I never used it before.