Test either of these to chose the one you realy want.

SELECT USER_NAME();

GO

SELECT SUSER_SNAME();

Here is an example of its use:

CREATE TABLE #Orders(

[UPC] [varchar](50) NOT NULL,

[SuggestedPrice] [money] NULL,

[Addedby] [Varchar] (45))

CREATE PROC...

There may be others with the same thought. ...

If I am reading your posting correctly (and there is a good chance that I am not) in the Product table, you have designated the Product_ID (PK). Where I take...

When going to "Recent Posts", this shows up:

http://www.sqlservercentral.com/scripts/CROSS+JOIN/87362/

Note that it is a SCRIPT so why oh why is it appearing in "Recent Posts" - another foul up something like what...

This might give you an idea of how to do what you want to do.

http://www.sqlservercentral.com/articles/T-SQL/71550/

It is an excellent discussion by Jeff Moden with sample code to do what I think...

SQL Kiwi (2/17/2012)

---

This is completely the wrong approach, in my opinion. I prefer to...

The subject of these self driving or assisted driving cars got me to search the web. Try viewing these

Nevada Becomes First State To Regulate Self-Driving Cars ...

Looking for something like this:

DECLARE @HireDate DATETIME

DECLARE @CurrentDate DATETIME

SET @HireDate = '01-06-2012'

SET @CurrentDate = GETDATE()

SELECT DATEPART(wk, @CurrentDate) - DATEPART(wk,@HireDate) AS 'Weeks Worked'

--Result:

Weeks Worked

6

Jeff Moden (2/17/2012)

---

Evil Kraig F (2/17/2012)

---

GSquared (2/17/2012)

---

bitbucket-25253 (2/17/2012)

---

Way way back Virginia Tech was working on a system with a buried cable in each lane, a sensing mechanism on the front...

Revenant (2/17/2012)

---

GSquared (2/17/2012)

---

bitbucket-25253 (2/17/2012)

---

Getting away from cold weather and all, I can remember back to 1950 when an uncle of mine gave me his old, old beetle so it must...

Getting away from cold weather and all, I can remember back to 1950 when an uncle of mine gave me his old, old beetle so it must have been say...

Koen Verbeeck (2/16/2012)

---

Revenant (2/16/2012)

---

Grant Fritchey (2/16/2012)

---

Stefan Krzywicki (2/16/2012)

---

Brandie Tarvin (2/16/2012)

---

Can I just say, I hate that nothing dies in Florida? For those of you experiencing winter, please send snow in...

Just shows that you must read the comments posted on any published article.

Look at this "Spackle" article by Jeff Moden, I think it might do what you want to do.

http://www.sqlservercentral.com/articles/T-SQL/71550/

zeeshandar (2/16/2012)

---

Hi,

Let me explain what I am trying to do in Steps:

I have:

- Sql server 2005 at my hosting

- Sql server 2000 at my office computer

I want to download complete...