To combine all records from one or multiple resultsets use UNION [ALL]

To combine all columns from one or multiple resultsets use JOIN (eg. INNER, LEFT/RIGHT OUTER, FULL OUTER)

If you...

SpinyNorman (3/15/2013)

---

I'm not sure why the sub-selects are being generated, but removing them doesn't make a difference. It's almost as if the query is trying to use the filtered index...

How big your table is? Or, better way, how many records will stay in the table after purge of records for the last two years?

You might find, that moving the...

I guess you have no choice here. PK can only be set "at table level"

...every time remove pk before proc executes then...

It's quite common design when DB connection is made...

Can you try this one (with index enabled):

SELECT

[Extent1].[ValuationDateID] AS [ValuationDateID],

[Extent3].[TransactionRef] AS [TransactionRef],

[Extent3].[Counterparty] AS [Counterparty],

[Extent2].[BookName] AS [BookName],

[Extent2].[Category] AS [Category],

[Extent2].[Type] AS [Type],

[Extent2].[LifeLicence] AS [LifeLicence],

[Extent2].[Manager]...

Ough, that's fine. I just couldn't see all closing brackets from first glance.

There are many different reason for this error to happen.

Have you seen this one? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36409

You have posted incomplete statement...

Note, dbo.DelimitedSplit8K is the fastest way to split sting in T-SQL (it only will marginally loose to CLR implementation). Also, what will happen if your Category will include 3 or...

romah (3/14/2013)

---

Thank you SSCrazy for your quick reply.

Now, I got the following error:

"Category" is not a recognized table hints option. If it is intended as a parameter to a table-valued...

With Jeff Moden help ( dbo.DelimitedSplit8K string split function - http://www.sqlservercentral.com/articles/Tally+Table/72993/ )

you can do just this:

declare @mytable table (SNo int, Category varchar(100))

insert @mytable

...

Keep searching.... :hehe:

I also like to invent bicycles in my free time. Stupid clients/employers, they don't like to pay me for spending time on such an exciting hobby of mine...

What about rules?

Why not

1 50

and

5 50

?

ChrisM@Work (3/14/2013)

---

Eugene, that is absolutely spot on, and your last sole-user sample is an excellent demonstration of the distribution limitation. However, the sample sets provided by the OP are in...

RVO (3/13/2013)

---

My boss is a professional. He was a developer recently.

I saw some of his stored procedures - good code.

I think he has a point. A few years ago at...