Correct answer is "C", not "D".

Clauses, WHEN MATCHED and WHEN NOT MATCHED are the standards as per ANSI.

Microsoft extended these to WHEN NOT MATCHED BY SOURCE to make things more...

My question is today the output file which is generated by the script came out as having no data. So my question is; is there a way to find out...

I've not tested this, but something like this you can use as starter and do modifications to make it stable:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[sp_PagedItems]

(

@ID...

Check the blog posts I've written on:

1. Creating Stored Procedures with Dynamic Search (filter)[/url]

2. Creating Stored Procedures with Dynamic Search & Paging (Pagination)[/url]

3. Creating Stored Procedure with Dynamic Search, Paging...

@Gail, sorry for responding to a 3yr old thread, and also attempting to promoting my blog post.

But it's NOT a SPAM as still this exam 70-461 is latest and lot...

Delta column in a table is use to do Incremental/Delta loads.

So the prospective Delta columns in your tables could be audit columns like, UpdateDate/ModifiedDate, timestamp, rowversion, ETL_LoadID, etc.

Using CustomerID would...

My apologizes @jeff and other users.

I thought to reply on some related threads, but didn't realized that I was doing this too much.

Sorry for spamming.

For exam details and on what to prepare for 70-461 Exam check the following blog post:

Link:http://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/[/url]

For exam details and on what to prepare for 70-461 Exam check the following blog post:

Link:http://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/[/url]

Yes, the training kit would be enough to pass the exam.

However, you will have to practice with SQL Queries a lot if you are new to TSQL.

Regarding XML, don't fear,...

Never use and rely on DUMPs, study, practice, that's it.

The exam could be simple for few people, but complex for newbies, it depends upon on what level you are.

Here is...

Here is my experience after giving this exam and all the details on what is being asked and references on how to prepare for 70-461 Exam.

Link:http://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/[/url]

Yes, the book is suffecient to prep for the exam. But you will also have to practice with SQL Queries in SSMS.

For people working with TSQL and 5-10 yrs of...

Yes the book is worth byuing, and you can get it from Amazon, link.

As you said you are already working with SSIS/AS/RS, so the exams should be easy for you....

Congrats on passing 70-461, for BI you need to give 70-463, check here for reference: http://sqlwithmanoj.com/2013/12/05/preparing-for-70-463-exam-implementing-a-data-warehouse-with-microsoft-sql-server-2012/[/url]

SQL Server 2012 Certification path: http://sqlwithmanoj.com/2013/11/06/sql-server-2012-certification-path/[/url]

Exam 70-461: http://sqlwithmanoj.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/[/url]