select distinct T1.Product_name, Product_budget, T1.Month

from [Product Table] as T1

inner join [Product Budget] as T2

on T1.Product_ID = T2.Product_name

and T1.Month = T2.Month

where T1.Product_ID = 10001;

Looks like that should...

Condolences and prayers to your friend's family and all who knew him.

On the subject of living for the present as well as the future, I like to remind people that...

Craig Farrell (4/20/2011)

---

You know, this is why I'm never quite sure if I should write tech articles. ...

So for the rest of you tech article writer/bloggers, instead of helping...

If the code doesn't later use the @rc variable for anything, then no, there's no reason to store the return-value in it.

You can use the Return command to return any...

K. Brian Kelley (4/20/2011)

---

That seems to be the real issue. Are you sure the username wasn't mistyped and that it existed in the database as a...

EXEC @rc = Mydb.dbo.Usp_mytable_Insert

@ProcessId,

@dEnddate,

@sMessage,

NULL, NULL, NULL, 0, 1, 'Error', NULL, NULL

All of that is the command to execute the stored procedure. These are parameter values:

@ProcessId,

@dEnddate,

@sMessage,

NULL, NULL, NULL, 0, 1,...

You could use Min() or Max() on the name, and group by the rest of it. Won't control which one you show, but will only show one.

So far as I can tell, you'll need to check if he's been denied any rights in that direction. Those would override the role.

I'd have to see details before I could recommend anything. Table structures, et al, will be needed in order to recommend anything sensible.

GilaMonster (4/20/2011)

---

LutzM (4/20/2011)

---

Is there any other method than using the mouse pointer? There are so many words on the screen. How else to keep track where the next word is...

I would say the better solution is to properly protect the server login credentials.

This has options for formatting dates and times: http://msdn.microsoft.com/en-us/library/ms187928.aspx

I'm always interested when people rediscover the master-journeyman-apprentice system, or pieces of it. It solves so many problems.

I'd do that with the firewall, not in SQL Server. That's what firewalls are for.

WayneS (4/19/2011)

---

Oh, he's setting an example all right - just not the kind that is appreciated out...