Here you go

the problem was on your join

SELECT dimUser.EmpFullName1 [User Name]

...

fair enough. then the code ive supplied will work a treat if thats the column name for the real date

without knowing the columns on your Date Dimension table i assume its called ActualDate, here is a solution which doesnt require any conversion, since it should of already been done...

can you join to the dim.date table twice once for each date and then return the actual date, which i'd expect to be stored in most date dimension tables?

Interesting. i may have to reconsider my own usage of defaulting to while loops now.

Thanks for the pointer Gila

be wary of the Brackets, can you post the modified code with the column name in it?

here's an example :

SELECT a.custno

, RTRIM(a.firstname) + ' ' + RTRIM(a.lastname) AS name

, company

...

i've done this at my previous place and found assignment of a scoring algorithm the best method.

you'll need to build the score based on what you think is...

This should do it, exchange GETDATE() for the date you deriving the column from. Apply the Logic to the Hours/minutes/seconds if you need to suffix 0's to that also.

(DATEPART(...

When i have had to do this in the past i have had to use a derived column which is of type DT_STR and then write a fairly complex expression...

ive made a couple assumptions but this should work:

CREATE TABLE #TEMP1

(

patId INTEGER NULL

, ancienPatId INTEGER NULL

)

PRINT 'Find patient with no phone number...

i'd say either define the columns your inserting into or add the value 0 to the select statement so you are passing a value through to the "seen" column

maybe that...

have you ever used a while loop in SQL.. i tend to use these over cursors these days and find they perform a lot better.

here is a sample code...

no problems.

what i did was break out the login and logout sets and assign a row number to each login and log out. Then join this data back on...

the below SQL should do what you need and also covers when people login and out multiple times.

I have assumed if they havent logged out they are still logged in

IF...