I recently got many emails requesting to write a simple article. I also got a request to explain different ways to insert the values from a stored procedure into a table. Let us quickly look at the conventional way of doing the same with Table Valued Function.
SQLAuthority News – Article 1100 and Community Service
This is 1100 the post of on my blog post on this blog. Just looking at the last 100 post of my blog, I have realized besides writing blog posts there are lots of other community events, I have been involved with. Let me quickly list few of the important…
Read MoreSQL SERVER – Introduction to Service Broker and Sample Script
Service Broker in Microsoft SQL Server 2005 is a new technology that provides messaging and queuing functions between instances. The basic functions of sending and receiving messages forms a part of a “conversation.” Each conversation is considered to be a complete channel of communication. Each Service Broker conversation is considered…
Read MoreSQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location
I was reading the blog of Ward Pond, and I came across another note of Microsoft. I really found it very interesting. The given explanation was very simple; however, I would like to rewrite it again. Let us execute the following script. This script inserts two values ‘A’ and ‘B’…
Read MoreSQLAuthority News – SQL Server Accelerator for Business Intelligence (BI)
I have wonderful experience at my recent Business Intelligence tour. I will write down in detail about my experience at different location. However, today I would like to talk about one particular question which was asked at all the locations. It was about SQL Server Accelerator for Business Intelligence (BI).…
Read More
SQLAuthority News – Community Tech Days Oct 3, 2009 – Ahmedabad
Dive deep into the world of Microsoft technologies at the Community TechDays and get trained on the latest from Microsoft. Build real connections with Microsoft experts and community members, and gain the inspiration and skills needed to maximize your impact on your organization while enhancing your career. What more… You can watch some of these sessions LIVE online, from the comfort of your workstation as well.
SQL SERVER – Converting Stored Procedure into Table Valued Function
In one of my recent articles, I mentioned the use of Table Valued Function (TVF) instead of Stored Procedure (SP). I received a follow up email asking what type of SP can be converted into a TVF. This is indeed a very interesting question! In fact, not all the SPs…
Read More