Answer / sumit ranjan

Stored procedures simplify Analysis Services database development and implementation by allowing common code to be developed once and stored in a single location. Stored procedures can be used to add business functionality to your applications that is not provided by the native functionality of MDX.



create procedure myproc
@gender varchar(30)
as
begin

What is collation sensitivity?

0 Answers  

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

---

What is the difference between cartesian product and cross join?

0 Answers  

---

Create and insert into temp table in sql server?

0 Answers  

---

What is a trigger and types of a trigger?

0 Answers  

---

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---

Can you explain what is the use of custom fields in report?

0 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

---

Explain the rules for designing files and file groups in sql server?

0 Answers  

---

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

---

What is the difference between a function and a stored procedure?

0 Answers  

---