Why not just count them??

SELECT Schema_name(t.schema_id) AS schema_name,

t.name ...

You will have to do a little bit of manual work to compare what features are available by edition across the versions but this will show all the features and...

L' Eomot Inversé (9/20/2013)

---

But talking of code I don't like, I saw something I liked even less yesterday (on SSCentral):

select ...

from Table1 T left join...

You can have a rollback inside the try block.

begin try

begin transaction

insert stmt

if value>1

rollback --Or you could use RAISERROR

--Raising an error might be a better approach if you want to...

You have a couple of issues going on here. First is the fact that this function will not perform well because it is a multi-statement table function. The performance of...

Other than what must be horrific performance with a proc that has a cursor which calls another proc which has cursor what is the issue?

You could easily turn this into a view on your remote server. There is no need for any variables here.

select '000' + ltrim(MCMCU)

, CASE datepart(month, dateadd(month, -2, getdate()))

WHEN 1...

jkalmar 43328 (9/19/2013)

---

I finally found an article that explained that the parser expands all CASE statements, which is why the linked server sees this as nested. I ended up splitting...

I have run into this in the past. The error message makes no sense but you can't have more than 10 when clauses in a case expression when querying over...

You...

There is not really a terribly efficient way to do this. You are going to have to type in all the columns. something like this might help make it somewhat...

There is no need to resort to looping for this. You can instead use STUFF.

Thanks Mark for the ddl and sample data.

declare @a table (Linenumber int, ErrorText varchar(30),FileID int)

insert into...

It seems you need some help with this. Many people around here would be happy to help. In order to help we will need a few things:

1. Sample DDL in...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1496302-392-1.aspx

Looking at your original post again I think that Col2, Col3 and Col4 are just noise to the problem? All that really matters here is Col1 and Col5.

Here is an...