LOL glad you figured it and thanks for posting back.

Can you provide a bit more detail? Can you post some of the code and perhaps the actual string?

Take look at this post. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

Please note this is a 10 year old thread...

Did you try google???

Search for "Error 21268: [SQL-DMO]Row or...

OK I will ask one last time. Please provide some ddl and sample data along with a clear explanation of what you are looking for. You have been asked multiple...

Here is a script that can do that. Please note this is NOT fast and I would recommend NOT running this in production. Make a backup and stick it on...

sabercats (2/29/2012)

---

Sorry, my query is

****** Script for SelectTopNRows command from SSMS ******/

declare @dow int

declare @2SundaysAgo datetime

declare @lastSaturday datetime

select @dow = datepart(dw, getdate())

select @2SundaysAgo = getdate() - (7 + (@dow -...

Keep in mind that nobody here can see your screen and we are not familiar with your project.

You said

Here are my full query and it did not get...

You have to wrap the name with []

select * from dbo.[tbl_ec_cpoassignments(obsolete)]

Here is a create, select and drop as an example

create table [funkyName(obsolete)]

(

Seriously varchar(10)

)

go

select * from dbo.[funkyName(obsolete)]

go

drop table [funkyName(obsolete)]

TeraByteMe (2/29/2012)

---

I am trying to update filename records in a temp table by using the REPLACE function. I can't think of how to do this all in one statement so...

My guess is that is the table name. Some dev trying to indicate that this table is obsolete. Not the greatest way to have built it but there is nothing...

thanks for the ddl and sample data. What do you want as a result of your query based on this sample data? I am not getting what you mean taking...

It is very tricky without some ddl and sample data to work with. A clear explanation of what you want as output would help to. Take a look at the...

You would have to use dynamic sql for every single query. I don't know that is the way I would go with it.

I too suspected this wasn't going to end up set based because of the nature of the whole thing. I sort of eluded to that in my post that the...