Jeff Moden (1/10/2016)

---

...Last but not least, you've made the code work and that's great. Next, the above code will help make it fast. Now you need to make...

First of all you need to provide the full and complete information, remember that we cannot see or know anything that's not posted here! Suggest that you post the DDL(create...

UDF is the equivalent...

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to convert this into yyyy-mm-dd ...

adas-768309 (7/18/2011)

---

Hi all

I have been using SQL server 2005 Standard (32-bit).

I am planning to upgrade to 64 bit. But unfortunately I cant find a download link for SQl server 2005...

Duplicate post!

😎

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...