Styjun

Whipping heavy cream with melted chocolate

Did Hitler say this quote about homeschooling?

Real orthogonal and sign

How to extract interesting piece of output in bash

Improving an O(N^2) function (all entities iterating over all other entities)

Who or what determines if a curse is valid or not?

How would you say "Sorry, that was a mistake on my part"?

Can error correction and detection be done without adding extra bits?

Why are there few or no black super GMs?

🍩🔔🔥Scrambled emoji tale⚛️🎶🛒 #2️⃣

How can I help our ranger feel special about her beast companion?

Why do jet engines sound louder on the ground than inside the aircraft?

Why isn't a binary file shown as 0s and 1s?

When designing an adventure, how can I ensure a continuous player experience in a setting that's likely to favor TPKs?

How important are the Author's mood and feelings for writing a story?

Applying for jobs with an obvious scar

What is this green alien supposed to be on the American covers of the "Hitchhiker's Guide to the Galaxy"?

Is it legal for a supermarket to refuse to sell an adult beer if an adult with them doesn’t have their ID?

May I use a railway velocipede on actively-used British railways?

Does unblocking power bar outlets through short extension cords increase fire risk?

Who determines when road center lines are solid or dashed?

Why teach C using scanf without talking about command line arguments?

Diagram of Methods to Solve Differential Equations

What makes MOVEQ quicker than a normal MOVE in 68000 assembly?

How to create a stored procedure in SQL Server which creates dynamic partitions and process for the tabular model

How to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?How to concatenate text from multiple rows into a single text string in SQL server?What is the best way to auto-generate INSERT statements for a SQL Server table?Function vs. Stored Procedure in SQL Serversql server invalid object name - but tables are listed in SSMS tables listHow do I escape a single quote in SQL Server?How do I UPDATE from a SELECT in SQL Server?Search text in stored procedure in SQL ServerHow to Delete using INNER JOIN with SQL Server?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

How to create a stored procedure in SQL Server which creates dynamic partitions and process?

I have below code which creates a partition every time, and does process at one time in liked server.

Using below code I would like to create dynamic multiple partitions and process by passing partition name and fiscal period id to the procedure dynamically.

Please suggest.

declare @xmla varchar(max) = '

 "createOrReplace": 
 "object": 
 "database": "FlashArchive",
 "table": "FORECAST_FLASH",
 "partition": "FORECAST_FLASH_368"
 ,
 "partition": 
 "name": "FORECAST_FLASH_368",
 "source": 
 "query": "select * from FORECAST_FLASH_ARCHIVE_V where fiscal_period_id=368",
 "dataSource": "itv.world"
 
 
 

';

EXEC (@xmla) AT SSAS;



declare @xmlap varchar(max) = '

 "refresh": 
 "type": "automatic",
 "objects": [
 
 "database": "FlashArchive",
 "table": "FORECAST_FLASH",
 "partition": "FORECAST_FLASH_368"
 
 ]
 

';
exec (@xmlap) at SSAS;

sql-server sql-server-data-tools ssas-tabular xmla

share|improve this question

edited Mar 26 at 11:10

marc_s

597k135135 gold badges11481148 silver badges12841284 bronze badges

asked Mar 26 at 10:14

saijsaij

744 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So basically you want to create a stored proc that takes a fiscal period, which is a number, for example, 368, and creates a partition and refreshes that partition. It would appear that all you need to do is concatenate this number into the correct part of the string. Do you know how to concatenate strings in T-SQL?
  
  – Nick.McDermaid
  Mar 26 at 11:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Nick.McDermaid I want to pass partition name and fiscal period dynamically to a stored procedure.
  
  – saij
  Mar 26 at 11:39
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If the fiscal period is 368 then the partition name is just FORECAST_FLASH_368 right? so you only need to pass in the fiscal period. Your first task is to work out how to create a stored prcoedure that takes a VARCHAR parameter
  
  – Nick.McDermaid
  Mar 26 at 11:49
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Nick.McDermaid I have created stored procedure,which takes VARCHAR parameter.I am unable to find that how to fix above code in procedure and execute in linked server.
  
  – saij
  Mar 26 at 11:59
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you edit your question and post the entire stored procedure. If your parameter name is @FiscalPeriod then all you have to do is concatenate that to your existing strings. If you are having issues please explain in detail.
  
  – Nick.McDermaid
  Mar 26 at 13:01
  

  
  
  
  

add a comment | 

0

How to create a stored procedure in SQL Server which creates dynamic partitions and process?

I have below code which creates a partition every time, and does process at one time in liked server.

Using below code I would like to create dynamic multiple partitions and process by passing partition name and fiscal period id to the procedure dynamically.

Please suggest.

declare @xmla varchar(max) = '

 "createOrReplace": 
 "object": 
 "database": "FlashArchive",
 "table": "FORECAST_FLASH",
 "partition": "FORECAST_FLASH_368"
 ,
 "partition": 
 "name": "FORECAST_FLASH_368",
 "source": 
 "query": "select * from FORECAST_FLASH_ARCHIVE_V where fiscal_period_id=368",
 "dataSource": "itv.world"
 
 
 

';

EXEC (@xmla) AT SSAS;



declare @xmlap varchar(max) = '

 "refresh": 
 "type": "automatic",
 "objects": [
 
 "database": "FlashArchive",
 "table": "FORECAST_FLASH",
 "partition": "FORECAST_FLASH_368"
 
 ]
 

';
exec (@xmlap) at SSAS;

sql-server sql-server-data-tools ssas-tabular xmla

share|improve this question

edited Mar 26 at 11:10

marc_s

597k135135 gold badges11481148 silver badges12841284 bronze badges

asked Mar 26 at 10:14

saijsaij

744 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So basically you want to create a stored proc that takes a fiscal period, which is a number, for example, 368, and creates a partition and refreshes that partition. It would appear that all you need to do is concatenate this number into the correct part of the string. Do you know how to concatenate strings in T-SQL?
  
  – Nick.McDermaid
  Mar 26 at 11:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Nick.McDermaid I want to pass partition name and fiscal period dynamically to a stored procedure.
  
  – saij
  Mar 26 at 11:39
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If the fiscal period is 368 then the partition name is just FORECAST_FLASH_368 right? so you only need to pass in the fiscal period. Your first task is to work out how to create a stored prcoedure that takes a VARCHAR parameter
  
  – Nick.McDermaid
  Mar 26 at 11:49
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Nick.McDermaid I have created stored procedure,which takes VARCHAR parameter.I am unable to find that how to fix above code in procedure and execute in linked server.
  
  – saij
  Mar 26 at 11:59
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you edit your question and post the entire stored procedure. If your parameter name is @FiscalPeriod then all you have to do is concatenate that to your existing strings. If you are having issues please explain in detail.
  
  – Nick.McDermaid
  Mar 26 at 13:01
  

  
  
  
  

add a comment | 

How to create a stored procedure in SQL Server which creates dynamic partitions and process?

I have below code which creates a partition every time, and does process at one time in liked server.

Using below code I would like to create dynamic multiple partitions and process by passing partition name and fiscal period id to the procedure dynamically.

Please suggest.

declare @xmla varchar(max) = '

 "createOrReplace": 
 "object": 
 "database": "FlashArchive",
 "table": "FORECAST_FLASH",
 "partition": "FORECAST_FLASH_368"
 ,
 "partition": 
 "name": "FORECAST_FLASH_368",
 "source": 
 "query": "select * from FORECAST_FLASH_ARCHIVE_V where fiscal_period_id=368",
 "dataSource": "itv.world"
 
 
 

';

EXEC (@xmla) AT SSAS;



declare @xmlap varchar(max) = '

 "refresh": 
 "type": "automatic",
 "objects": [
 
 "database": "FlashArchive",
 "table": "FORECAST_FLASH",
 "partition": "FORECAST_FLASH_368"
 
 ]
 

';
exec (@xmlap) at SSAS;

sql-server sql-server-data-tools ssas-tabular xmla

share|improve this question

edited Mar 26 at 11:10

marc_s

597k135135 gold badges11481148 silver badges12841284 bronze badges

asked Mar 26 at 10:14

saijsaij

744 bronze badges

declare @xmla varchar(max) = '

 "createOrReplace": 
 "object": 
 "database": "FlashArchive",
 "table": "FORECAST_FLASH",
 "partition": "FORECAST_FLASH_368"
 ,
 "partition": 
 "name": "FORECAST_FLASH_368",
 "source": 
 "query": "select * from FORECAST_FLASH_ARCHIVE_V where fiscal_period_id=368",
 "dataSource": "itv.world"
 
 
 

';

EXEC (@xmla) AT SSAS;



declare @xmlap varchar(max) = '

 "refresh": 
 "type": "automatic",
 "objects": [
 
 "database": "FlashArchive",
 "table": "FORECAST_FLASH",
 "partition": "FORECAST_FLASH_368"
 
 ]
 

';
exec (@xmlap) at SSAS;

sql-server sql-server-data-tools ssas-tabular xmla

sql-server sql-server-data-tools ssas-tabular xmla

share|improve this question

edited Mar 26 at 11:10

marc_s

597k135135 gold badges11481148 silver badges12841284 bronze badges

asked Mar 26 at 10:14

saijsaij

744 bronze badges

share|improve this question

edited Mar 26 at 11:10

marc_s

597k135135 gold badges11481148 silver badges12841284 bronze badges

asked Mar 26 at 10:14

saijsaij

744 bronze badges

edited Mar 26 at 11:10

marc_s

597k135135 gold badges11481148 silver badges12841284 bronze badges

edited Mar 26 at 11:10

marc_s

597k135135 gold badges11481148 silver badges12841284 bronze badges

asked Mar 26 at 10:14

saijsaij

744 bronze badges

asked Mar 26 at 10:14

saijsaij

744 bronze badges