Here's the link to the duplicate, which is where I provided an answer:

http://www.sqlservercentral.com/Forums/Topic558547-6-1.aspx

I believe the function is SUSER_SNAME() or you can use SUSER_NAME(). For domain logins they return domain\username

Oh, and please don't cross post.

Thanks,

I'd definitely think migrating to SQL Server at least Express edition would be warranted. Access is really not designed to be multi-user back end. I'd think that the...

In order to toggle visibility of items in SSRS you have to have something you "toggle on".

Will the user know which they want to see before they run...

pete.trudell (8/25/2008)

---

Aaya is giveng us the time in Seconds, we then us 86400 to get Minutes and seconds. So I suppose I could divide the second by Avaya by...

What is the trigger to decide which one is visible? Is there ever a time when both should be visible?

They don't like it because they don't really understand it. Sure, you can do it all in SSIS Data Flows and it will work, but updating 1000 or more...

How does 1803/86400 = 30 minutes 3 seconds (30:03)? Or is 1803 the result of the time time divided by 86400? What is the base for the time?

Are you using Fast Load in the destination with table lock? If you are I'd go away from that as the tasks are trying to run in parallel and...

If your Execute SQL Task is not in a loop and does not contain loops or cursors then I'd say your performance will be best using that task. If...

When you set up your database mail profile and account did you set it up to use SSL? See my first post.

Did you check the "This server requires a secure connection (SSL)" box? It sounds like that is what it is after.

Could you give us a little more information? Table names, column names? Do you mean joining 3 tables or using 3 columns to join 2 tables?

Here's an example of...

I think this will work:

[font="Courier New"]DECLARE @x TABLE (id CHAR(3), name CHAR(2), value CHAR(2))

DECLARE @y TABLE (name CHAR(2), value CHAR(2))

INSERT INTO @x

   SELECT

       'AXN', 'E1', 'N1'

   UNION ALL

   SELECT

       'AXN',...

Where are you creating and assigning the value ('M' or 'P') to a variable?