Hi Grant,

I just realized that you are the author of a book focused on t-sql query performance.

I believe such a usage will affect the performance of SQL Server in a...

In fact, I can not see any advantage by creating a view within a stored procedure.

But what I'm interested is that the sql engine successfully compiles the sp code without...

Hi Ankur,

Actually we have to add the DROP VIEW command within the procedure, otherwise a second call to SP will cause an error.

Here is a better version.

CREATE PROC USP_VIEW

AS

DECLARE

Hi Ankur,

You can use dynamic sql statements.

Here is a sample script

CREATE PROC USP_VIEW

AS

DECLARE @sql nvarchar(max)

SET @sql = N'CREATE VIEW view_name AS SELECT TOP 3 * FROM...

Hi Raunak,

It has been long I have...

70-448 is requirement for MCTS - SQL Server 2008, Business Intelligence Development and Maintenance certification

Additionally if you...

Hi Abrar,

Both documents have the same pre-requisites for same certifications.

They can be considered the same. The opposite can not be thought also.

Actually I got the certification paths document from Learning Rewards Program downloads.

I have some experience with SQL Server 2005 and Reporting Services but lost my job in the recession. After alot of thought I have decided I want to persue a...

Hello Mike,

Passing 70-431 is enough to complete requirements for MCTS : SQL Server 2005 certification

And completing other two exams (443 and 444) on top of 431 will earn you the...

🙂

After Michael, Paul has the shortest statement ever ... Great!

Hi nguyennd,

You are genius 🙂

I was so detailed with mod, division, etc.

You made the query more simple.

U can try this

SELECT

CASE WHEN (@Date % 100) = 12 THEN

((@Date / 100) + 1) * 100 + 1

ELSE

(@Date / 100) * 100 + (@Date % 100)...

SSRS (SQL Server Reporting Services) is definelty a good reporting tool that is working very effective in my production environments.

You can use it integrated with SharePoint portal applications, or stand...

Hi Goldie,

The following script is giving the outcome you want in my test database.

As you will see there is a string split function within the first part of the sql

Then...