jbalbo (11/20/2012)

---

Hi,

Not sure how to set this up?

INSERT INTO PROVIDER_TO_TRUSTED_PROVIDER_COLLECTION

OID_LINK = '003A19E3D3B040958EFA16EB2585B0DC', OID=oid

SELECT PROVIDER_TO_TRUSTED_PROVIDER_COLLECTION.OID, PROVIDER_TO_TRUSTED_PROVIDER_COLLECTION.OID_LINK

FROM dbo.PROVIDER_TO_TRUSTED_PROVIDER_COLLECTION where OID...

Looking at your code I don't quite see how that is possible. How many...

That looks like it is a...

Since nobody else has asked...couldn't these two triggers be combined into a single trigger with 1 insert statement?

SELECT INSERTED.PO_Number + INSERTED.AppUser + INSERTED.SoftwareShortName + INSERTED.HeatTicketNumber

,(INSERTED.Unit_Price * - 1)

,'823008'

FROM INSERTED

WHERE INSERTED.Transaction_Type...

lex9120 (11/20/2012)

---

Also,

by any chance does anyone have an idea on how to perform the following?

I need to create a stored procedure named PartInventory that returns a grid (temp table)....

You also should not keep creating new threads for the same thing. Your answers are all over the place. It would be far easier to use the same thread for...

Guru Nagabhushan (11/20/2012)

---

One would assume that the rows are ordered in exactly the same way in both tables. if that is true, you could first select into a temp table...

You need to provide a LOT more information before anybody can begin to answer your question. In fact, you haven't really posted a...

sqldba4u (11/20/2012)

---

There is requirement to track who is accessing which view and at what time. There are numerous views in databases in SQL 2000 instance which fetches confidential data. DB...

Lowell (11/20/2012)

---

based on the other thread for the same issue the problem is SOME of his data is YYYYMMDD as a decimal, like 20121225, but some of his data is...

You aren't...

Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1386842-391-1.aspx

SQL server rokee (11/20/2012)

---

Hello Fellow developers,

I'm a rokee when it comes to T-sql.

I have been trying to create a view from a table(lets call...

math martinez (11/19/2012)

---

Hi Jerome!

You don't need to use just to match the year and the month of your parameter. Try this query

SELECT MachineName, ModeName, FileName, UserName, StartDate, StartTime, EndDate,...

Are you saying you want the best performance? We can't tell you what is best. Read what G2 said above, unless there is a definitive reason to do otherwise,...