The column name goes after the END

case when ....

when ....

end as <column name>

/T

Well since i dont know how many countries you have to support its hard to know. A...

Well in that case. A CASE would probably...

Great question.

However... why does SQL let something get stored (and im not talking about the computed column itself since that aint stored... unless its persisted) in the database in...

scott_lotus (10/13/2010)

---

Realise this is probably an impossible question to answer without knowing the system but any feedback welcome.

4 Queries commited to SQL server 2005 TABLEA which contains 200M rows.

The running...

Something with Pivot maybe. One downside would be to get it to work when the month change. Probably some dynamic SQL is needed at that point. A small example.

declare

No perfect answer but maybe it can push you in the right direction.

create table #tbl (name varchar(128), s bigint)

declare @db varchar(128)

declare @sql varchar(2048)

select @db = ''

while exists (select...

Yes. As in Yes it will get effected.

/T

tdmech56 (10/11/2010)

---

I have a table employee with name and age as columns. I need a query with result as EMPNAME and count of employees with ages less than the current...

yjeevanrao (10/11/2010)

---

Hi,

I need to check on both conditions fld_totalstopnumbers and fld_empid. fld_totalstopnumbers should not have the numbers like as shown bellow.

1,3,3,4 here total stops 4 and employees are 4

1,5,6...

Okay replicating the tables and then running your code.

select distinct fld_tripid

from tbl_tripdet

group by fld_tripid, fld_StopNumber

having count(*) > 1

Produces the exact same result as your code. If thats wrong... your...

Taking a shot at what i think you need.

select ID, Stopnumbers

from tbl_Details

group by ID, Stopnumbers

having count(*) > 1

This would give you all ID/Stopnumbers which have more then...

Check out DateAdd

http://msdn.microsoft.com/en-us/library/ms186819.aspx

/T

Jeff Moden (10/10/2010)

---

A word of caution. These solutions are all "Triangular Joins". What are those? Well, a full up CROSS JOIN is also known as a "SQUARE...

Couldnt you try to find which record have the postcode in the wrong position? Depends a bit offcourse on how your postcode looks like. But here in Sweden an IsNumeric...