In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

davidandrews13 (11/15/2013)

---

i always felt that if the ID column was in a Table called 'State', then its self explanatory that its the 'StateID'.

so it was unecessary to call the column...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

It will perform better...

IgorMi (11/14/2013)

---

You question is not very clear, but guess what you're asking...

By specifying identity(1,1) primary key, you already have clustered primary key. For the property identity(1,1) there is no...

I would suggest that you take a look at the stairways articles right here on SSC. Proper knowledge of indexes is vital to the performance of your system.

http://www.sqlservercentral.com/stairway/72399/%5B/url%5D

Also, SQL server...

This is a type of catch all query. Check out this article for an explanation of how to handle this type of thing.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

You are quite welcome. 😀

Something like this?

select 'All' as code, 'All Locations' as name, 1 as SortOrder

union all

select code, name, 2 from location

order by SortOrder, WhateverOtherSortingCriteria

Chad Crawford (11/14/2013)

---

SQLRNNR (11/14/2013)

---

Greg Edwards-268690 (11/14/2013)

---

Show me the person who is a master of all things SQL Server.

They are as rare as seeing a unicorn!

SQL Server covers such a...

David Tooker (11/14/2013)

---

I figured out what I was doing wrong. I added back to the end of statement

GROUP BY Location,A.EmpId,EmpLastName,EmpFirstName,A.Type,A.Total_Hours.

that caused all the rows to be displayed.

Thanks...

Pretty sparse on details here. Not sure what you...

SteveEClarke (11/14/2013)

---

Thanks for your reply -

The problem is that there is a "Custom Database" setup which people have used Text/Char fields to store numeric in - what I am trying...

Phew!!! That is an understatement!!!

So do you have duplicates only on contact_number? If so, you could do something like this:

select...

Thanks for posting ddl and sample data. This goes a LONG way to making it easy on us.

This should work for you.

select ID, MAX(name), MAX(age), MAX(contact_number)

from #temp

group by ID