Hi Lynn,

Since the highest level reached is 1, for simplicity sake, you can remove the following:

DECLARE @lvl_limit AS int = 2;

and

WHERE lvl < @lvl_limit

----------------------------------

You can use the...

Hi Sean, I managed to create scripts which only includes the very minimum records, therefore no need to compress them. Attached the 3 scripts. First script is to create a...

Sean, if I had issue posting stuff how did I get my query posted ?

Secondly, if you download the files, open SQL Server, create a new database, paste the...

Hi Sean Lange, I listed the full query.

Unfortunately there is no way around the table scripts (includes both schema and data scripts),

I tried limiting the records for 'SR49931'...

Hi Koen, forgive me for not posting a new article, but I wanted a reply from you since I noticed you did your MCSA SQL Server 2012 - MCSE Business...

Hi, can I assume your query is for a report dataset ?

Hi Gail, thanks for the reply, just want to confirm the following:

I assume I should rather use these -

Snapshot isolation.

Read committed snapshot isolation.

Database Snapshot.

I assume...

OK,

In SQL 2012 you can have a read-only copy of the database - which you can use for SQL Reports,

in this case you can use READ UNCOMMITTED or skip...

For SQL Reports stored procedures you most definitely want to use "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED".

You only specify it once in the beginning of your stored procedure, as to...

Hi Steve, you mentioned -

We need to learn more about statistics and analysis to ensure that as we work with business people to query data, we understand what...

Hi Sergiy, firstly thanks to you and everyone else who responded to my post.

I think I should rather have named the title of my post:

How to find duplicates based...

Hi, perhaps I did not explain myself clearly, so I am trying to fix that.

I need to search a table with user records, find only those users that occur more...

sdhanpaul,

Prior to removing duplicate instance of user, I first want to get list of duplicate users, to do that I need to filter them and make sure they really...

Thanks GilaMonster, you're sharp, very sharp (and quick too).

Had one issue (two entire weeks were = week 53):

2011-12-31 00:00:00.000 Week 53

2012-01-01 00:00:00.000 Week 53

Replaced...

Hi, below I pasted 3 examples of Pivot (sample 2 is shows you that a case statement can be used to replace Pivot i you don't like Pivot method).

-- sample...