Hi,

i have doubt on table structure and design itself

in Workplace if its Primary key

then how can you put EmpNumber with it

each Employee have different Workplacecode ? if yes...

Try this One

select

* -- What ever column you want

,(case when Customer.CustomerID >3 then Order.PO else Order.OrderID end) as 'PO/OrderID'

from

Customer

inner join CustomerOrders on Customer.CustomerID =CustomerOrders.CustomerID

inner join Order on CustomerOrders.OrderID...

just go with practical scenario it may happen that email id same but domain different

in that case Just remove substring from "bitbucket-25253" solution

declare @T TABLE

(userid INT, emailname...

Yes my code is not at all optimize but yes it can be optimized

i was just giving one of solution using while loop that's i asked question first "do...

Check Redgate package tool

in that "Redgate compare" may help you

"Is Not" will not going to work you have to use != or <>

looking to your query it seems now problem is in and or combination you...

do you mean

you need to do this thing just with while loop not with cursor?

if yes then

declare @temptable table(i int identity(1,1) primary key,referencia varchar(50))

insert into @temptable

SELECT

referencia

FROM...

it seems fine from my side too.

can you please share some data and alse if possible table structure(involved in query)

so that have good visibility on query and can give...

do you have trigger in your any DB.(trigger may occupy lot memory)

as per my knowledge Sql server will utilize more memory(if its Free,no process required memory) unless and untill some...

What is Deptid datatype of Primary table.

both column datatype length should same of primary and child .

though try it from design view it may help you.

Hmmm but what if Skills are in different numbers for each ACCOUNTNO

Like

declare @skills TABLE

(

ACCOUNTNOVARCHAR(5),

...

it seems you have DD/MM/YYYY date formate

whats you column data type.

Question:but why you want maximum date in Min(Booked Date)

Like

Job Ref Max Date Min Date

C 12/10/2012 14/10/2012

now 14/10/2012 is maximum...

Not getting your question properly

can you share some more data and also give result which you want.

give some more details in question.

Same thing Using Join in CTE

declare @Checador TABLE (

i int identity (1,1),

TARJETA int,

HORA datetime,

FECHA date,

RELOJ int)

INSERT @Checador VALUES

(30 , '02/08/2010 08:14' , '02/08/2010' , 1 ),

(30 , '02/08/2010 12:57'...

It is my pleasure helping you:-)