You have a lot of performance hurdles to overcome in here. You have lots of nonSARGable code. You have functions all over the place in your join and where predicates....

Congrats Jack!!!

nishav2 (10/1/2014)

---

Hi ,

I am having similar kind of requirement.

I have a table.

create table dbo.test(ID int,Price decimal(18,9), Qty decimal(18,9))

Insert into dbo.test values(1,5000,5000000)

Insert into dbo.test values(2,3000,50000000)

Insert into dbo.test values(3,100,50000)

I need the output...

nishav2 (10/1/2014)

---

Hi ,

I am having similar kind of requirement.

I have a table.

create table dbo.test(ID int,Price decimal(18,9), Qty decimal(18,9))

Insert into dbo.test values(1,5000,5000000)

Insert into dbo.test values(2,3000,50000000)

Insert into dbo.test values(3,100,50000)

I need the output...

vecerda (10/1/2014)

---

Hello,

I need to auto increment an alphanumeric field in a table.

The process is as follows:

1. First position is static letter C for contact or static letter A for account...

WOOHOO!!! Congrats Jason!!! Well deserved sir!!!!

thedavegray (10/1/2014)

---

heh I know what you mean. I have been in at least one place where the intentionally gave me totally bizarre stuff like this to see how I would...

thedavegray (10/1/2014)

---

School was over thirty years ago...

I agree, they are strange requirements but in thirty years of working I've come to conclusion that in your second week at a...

These are all rather strange requirements which make me think this is likely school work. Things like denying access to views but allowing access to tables just doesn't seem to...

On the issue of your problem I have to agree with Kevin. This sounds like a much bigger topic than a forum is designed to deal with.

Today...

So what should the output be based on your sample data?

John Mitchell-245523 (9/30/2014)

---

Sean Lange (9/30/2014)

---

It doesn't actually matter what order the results are, the question didn't ask anything about what order they are in. It asked how many distinct values...

andrew.ing (9/30/2014)

---

Todd Reddinger (9/30/2014)

---

the ORDER BY in the OVER clause orders the records returned by the select. By adding an order by on the select, a differect set of records...

Koen Verbeeck (9/29/2014)

---

Sean Lange (9/29/2014)

---

I know that this is not neccesarily your design but starting all your table names with tbl_ and storing the datatype used in the column name...