Why does you manager want it done in C#?

This may well be the "Worst use of SQL, in 20 lines or less" that I have seen in quite some time... Nonetheless, here is how this can be...

Glad I could help.

You would use the MAX() aggregate function.

Typically, the Scripter has to use Dynamic SQL like this when the "Include IF NOT EXISTS" option is set.

Turn that off and you should see hardly any dynamic SQL in...

umanpowered (11/7/2008)

---

...Modified in terms of changing a column description, adding a column, doing some type of work on the Table Definitions itself, NOT the underlying data...is this correct from when...

What about the queue associated with the conversation's "FROM SERVICE"? Is there anything in it?

Note also, that messages associated with closed conversations in error, are not kept forever. ...

OK, show us what you get from:

select distinct Firstdisbursementdate

from tbSales

where Len(Firstdisbursementdate) > 8

OK, well then, the only way that I can see to do it with SMO is through a manual semi-shallow copy, like this:

Imports Microsoft.SqlServer

Imports Microsoft.SqlServer.Management

Imports Microsoft.SqlServer.Management.Common

Imports Microsoft.SqlServer.Management.Smo

Imports Microsoft.SqlServer.Server

Imports system.Data

Module...

OK, since you did not say "Yes" to SMO, I am going to assume that SQL script is OK.

Is the column at the end or in the middle of the...

I am not sure what is causing your problem, however, you can read my Code Camp presentation on typical Service Broker problems, either at my blog (see my signature) or...

billross (11/6/2008)

---

Threads can be rated. I rated this 5 stars because there is a lot of instructive stuff in this. It has been helpful to see techniques for expanding a...

You're welcome, uh, jcraw(?), but you know I don't like that nickname. 😀

Maybe, but what I have seen so far is just standard Relational Data issues that have not been fully normalized yet. I haven't seen anything that would lead me...

The thing is, Steve, that if you look at the examples given, it becomes clear that the "Groups" are not really groups in the typical sense: there is no commonality...