Thanks Chirag,

I will try that one out as soon as I get to office tomorrow. For some reasons I was doing exactly same didn't work, may be end of the...

Hi,

Even though this seems like a blunt reply, 3K items in a combobox is a nasty user interface design. You should provide some sort of filtering to reduce the number...

Sorry about the previous one where I said it wasn't working, I just woke up so I forgot one of the join

It's...

Thanks for the quick reply. I know Age should be calculated but it was just used as an example of INTEGER data.

I tried LEFT JOINS but didn't work..!

Inside Microsoft SQL Server 2005: T-SQL Querying ( ISBN: 0735623139 )

Inside Microsoft SQL Server 2005: T-SQL Programming ( ISBN: 0735621977 )

We have a similar situation and we use this.

IF EXISTS(SELECT [name] FROM [sysObjects] WHERE [name] = 'DateToDay' AND [type] = 'FN')

BEGIN

  DROP FUNCTION [DateToDay]

END;

GO

CREATE FUNCTION DateToDay(@InDate DATETIME)

RETURNS INTEGER

AS

BEGIN

 ...

Yeah I am preparing for it, just not sure how hard it will be..?

I have done MCSD, A+ so I assume this wont be harder than that and I got...

Aha...Thanks all

So the tables starting with # are named as

#PASummary20050101115959101__________________________...___CA1234567890 format where the rest is added by SQL Server to make...

Thanks Phills

If the temp tables are created uniquely then if 2 users call the same procedure at the same time then what will...

OK I will try that out and see what happens.

OK my bad. I have the function code at office but I can answer other questions.

What values do you get when you run,

SELECT TOP 1 P.RegionID, TD.SpecifiedSlump, TD.SpecifiedSecondSlump FROM tblTruckDocket...

it's a table function and it returns:

UID

Description

UpperLimit

LowerLimit

UpperTolerance

LowerTolerance

Label

ToleranceMarker