DOH!!! I am on a roll today. 😛

Not totally sure what you are after but is this close?

CREATE FUNCTION Getrate (@DATE DATETIME)

RETURNS TABLE

AS

create table #Result

(

Date datetime,

Value Decimal(18,10)

)

insert #Result

SELECT

DATE,Rate

FROM Current WHERE DATE < @DATE

if @@ROWCOUNT = 0

insert #Result

SELECT

DATE,Rate

FROM...

I understand what you are saying but honestly that doesn't make sense from a usability point. From your sample data you have lost this row.

It...

Is this in reference to detaching or dropping the database? There is now a checkbox for both of those operations to close any existing connections.

Well sure Ron that would work if you want a query that will perform better on larger datasets and is a lot easier to read than the one I came...

Nice work posting ddl and sample data plus desired output. That is a skill that all too often get overlooked around here. 😀

Something like this work?

select u.Userid, u.Locationid, case when...

No your sample data as you posted will not work. You...

Wow you really are frantic today. Slow down and ask your questions with enough details so somebody else can help you.

The above is what the others were asking you to do. You edited is since they asked but it was still totally unreadable. I have made it readable but it...

Here is the original post with what looks like code inside code blocks. Unfortunately it doesn't make any more sense when formatted than it did originally.

here iam having ...

True!! :blush: Old habits die hard.

You could do something like this...but I think this really belongs in front end code.

You could add "Application Name" to your connection string and then you can query that.

Server=(local);Database=xxx;Uid=xxx;Pwd=xxx;Application Name=MyNameHere

Now...

Perhaps...

What exactly are you looking for? What info could you pass in a connection string that would help with auditing?

Lowell I would be happy to kick the tires and provide some feedback.