Behind

Piling on, if for some reasons you don't want to use the unpivoting method then using three separate WHERE IN clauses is a much better option, it will use indices...

VegasL (1/10/2016)

---

Thank Hugo & everyone else..appreciate you're help. Performance at this stage is a non issue.

Hugo, I got Incorrect syntax near ';' when I tried:

SELECT ...

Hugo Kornelis (1/10/2016)

---

I'm pretty sure I already mentioned that the performance will be dramatic.

Also, if the table grows significantly I would index all three columns. I expect a plan with...

Hugo Kornelis (1/10/2016)

---

VegasL (1/9/2016)

---

Data comes that way. I can't normalize. I think this is analogous to an index match function from xls, which comepares one column against the other 3...

Further on Luis's fine answer, make certain that the proper POC (partition, order, covering) index is in place as it will remove the need for a very expensive sort operator...

Piling on Grant's fine answer, whenever I see a pattern like this I cannot help but thinking that there is something wrong in the design. If the stored procedure is...

Judging by the code posted on this thread, some people really don't like they're SQL Servers.

😎

Cheryl McLaughlin-385812 (1/6/2016)

---

That worked, thanks! I am showing what I did in case there is someone else that is in a similar situation:

CREATE PROCEDURE [dbo].[sfc_SPName]

@SCHEDULEDATE DATETIME

AS

SET NOCOUNT ON;

CREATE TABLE...

Luis Cazares (1/6/2016)

---

Here's a nice short article about concatenating strings:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Here's an example based on what you posted:

WITH CTE AS(

SELECT DISTINCT ID1, ID2, ID3

...

have2much (1/8/2016)

---

Hi,

I am new to sql server and trying to use resource governor to limit maxdop for DBCC CHEKDB and if possible for other maintenance job like backup and optimizing...

Start by reading Stairway to Integration Services[/url]

😎

Echoing Jeff and Hugo, we need more information in order to help with this problem.

😎

My thought is that this nested case approach may not be the correct one for this...

Don't think automating this is a good idea and especially on a remote server, anything goes wrong and it's...

Mac1986 (1/8/2016)

---

I might be the dummest person and i'm sure it might wront to recycle NICs one at a time at 15 hour interval. I'm seeing that IPV6 is slowing...