Storing date as a string is a sick idea but if you have to have it your way this is it:

SELECT CONVERT(VARCHAR, CONVERT(DATETIME, '18/11/07', 3), 1)

There is another twist to this buy/build debate. I know of businesses that built there own software because they could not buy the software that would fit into their business...

I agree that it works with the default settings but I do not like to depend on the settings too much... Unless I am dealing with a very controlled environment...

This can solve this without modifing the data...

SELECT ...

FROM table

WHERE NULLIF(field,'') IS NOT NULL

select * from Table

where customerID = ISNULL(@customerID, customerID)

if the customerID is not NULLable field.

Yes, you are right that code does not look right, which is surprising for Sergyi's code.

The ID should be coming from the Minutes tables not from the Schedule or TimePunch tables.

I...

Well, if you shifts and worked hours do not span days and you pull this info for a single day only then you  don't need the minutes for each day...

I am assuming you will be looking for this information based on a date range and this date range might be much smaller then the entire span off dates you...

Can you post the table definitions of the tables that hold the information about the work scheduled and the work actually performed? And maybe some test data. I got a...

Wow,

From the field names it looks like some kind of work schedule you dealing with. Are you working for the Chinese government of something?

Well, I never used temp tables that would span more then few datapages so I kind of assumed the temp tables we are talking about are small. I guess I can...

I would run some tests because only this will show you how one solution stacks up against another but I would be suprised if creating the indexes is going to...

I don't think creating indexes on the temp tables will buy you anything. The whole idea of indexes is to shorten your retrieval time by spending some extra time organizing your...

PRINT CONVERT(VARCHAR, GetDate(), 20)

PRINT CONVERT(VARCHAR, GetDate(), 120)

In your example you just converted from datatime to datetime (so the format just got ingnored - or maybe even the conversion) and the...

Jeff,

Is this why we pay so much for the phone service?

So they can pay you big bucks to write functions like this?