Posting sample data as demonstrated by the link in my signature has a much higher chance of garnering a response here.

Glad we could help. Thanks for the feedback.

Paul,

Try this one:

SET @sql = N'

UPDATE OPENQUERY(MYLINKEDORACLESERVER,''SELECT FIELDNAME FROM ORACLETABLE

WHERE IDFIELD = ' +

CAST(@AC AS VARCHAR(100)) + ''')' +

' SET FIELDNAME = ''' +

CAST(@myvalue AS VARCHAR(200))...

Jack Corbett

---

Can you post what your desired outcome looks like? Also post some test data so we can see exactly what you are working with and trying to do....

Use this to check your strings before you try to exec them. PRINT @sql. Then you can see what you are actually submitting, which right now,...

It seems to me that you're trying to establish a running count of rows in the table.. Please Note, you MUST have a clustered index on your current ID...

MrBaseball34 (10/27/2008)

---

Good job, Seth

I fixed the problem with the CoPays by loading them in the CTEs with the

InsPlan stuff I also fixed it to bring over the SubscriberID so...

The alternate solution requires a permanent field and an update to the entire table. It would also be necessary to update the totals each time a row was changed or...

Heh... yep.

You should just create views for this purpose(if you really need to create anything at all), as previously mentioned in this thread. What you're basically asking for with this...

What are you trying to accomplish with this?

SELECT Col1,

COUNT(Col3)+COUNT(Col4)+COUNT(Col5)+COUNT(Col6)+COUNT(Col7)+COUNT(Col8)+COUNT(Col9)+COUNT(Col10)+COUNT(Col11)+COUNT(Col12)

FROM table1

GROUP BY Col3

That code won't work because of an invalid group by, and your counts probably aren't going to give you...

Even if the triggers are exactly the same, you'll still have to change the ON clause of the triggers, and you should probably change the names of each one as...

Or... the even more elusive question... what on earth the end goal of this thing really is. Part of the reason we are unable to come up with any...

Indeed. And the best way is probably by using a Tally CTE ;).

Give this article a read. http://www.sqlservercentral.com/articles/TSQL/62867/

Then, if you need our help getting that applied to...

Fraggle (10/26/2008)

---

Pretty sure this isn't a Florida only forum. However, to my knowledge, SQL Saturday are Florida only. It does have similar counter parts in other states that...