jancas08 (2/27/2013)

---

Now, my rule is that: basically where ever there is an update you update the the table with the values. You determine what table to update by the error...

Right click the table(s) or other objects in SSMS. The script as --> To new window.

What I am talking...

The code you posted has changed significantly from the previous version. Your original code had only 1 statement inside a cursor. The recent code you posted has lots more logic...

I feel your pain Steve. We have been...

jancas08 (2/27/2013)

---

For example, the select statements finds 10 rows that contain 'UPDATE', it would do the sql execution on the 10 rows that contain 'UPDATE'. But, the use of printing...

You should use a unique constraint instead of a trigger to check for this type of thing.

http://msdn.microsoft.com/en-us/library/ms191166.aspx

Be careful here. Ed's approach...

pungigi (2/27/2013)

---

I need to be able to do the following

Year 2012...

asco5 (2/26/2013)

---

hi thanks for your reply

this is a example of what i want to do

as you see i have my data base and i have my application

i would...

jancas08 (2/26/2013)

---

I tried your way Lange; the only thing is that I can't view the selected data. For example, say the query ends up with 9 rows of data but...

You are quite welcome. Glad that worked for you.

Not...

shah.p.vishal (2/25/2013)

---

Hello

I have attached images with the sample data.

Basically I want to break notes column based on the ItemName coulmn. Notes column has combined ItemNAme column based on ItemId...

5280_Lifestyle (2/25/2013)

---

I'm trying to create a query with multiple columns. The CandidateID column includes values that appear more than once. I need my query to return the latest CandidateID value...

alvaro-454996 (2/25/2013)

---

Hi every one, so I have this view:

SELECT dbo.MOP10213.MANUFACTUREORDER_I, dbo.IV30300.DOCNUMBR, dbo.IV30300.DOCDATE AS fecha, dbo.IV30300.TRXSORCE

FROM dbo.MOP10213 INNER JOIN

...