Databases don't have IP addresses. The IP address belongs to the server. Like said before you would need to have named instances running to have the same db name multiple...

LOL. I will start...

Except that...

like this.

create procedure asdf

(

@Parameter varchar(10)

) as begin

--Comment block goes here.

select 5

end

For me this gives a nice visual separator in a long script to help isolate each sproc. It also allows...

I don't think there is a "best practice" for where to place your comments. The most important aspect is to be consistent. I tend to prefer them inside the body...

mmiller 85218 (2/6/2012)

---

I just know by the data but for this sample table, I am assuming that CatID 1 and CatID 3 can only have one option, the other 2...

You do know this...

One other question, you said

How do you know which ones can only have...

OK so do you want the number of possibilities or do you want the actual possibilities?

SQLKnowItAll (2/6/2012)

---

Sean Lange (2/6/2012)

---

SQLKnowItAll (2/6/2012)

---

I don't get it... I believe this is syntactically wrong, but I don't use try/catch blocks much. It seems wrong that your commit is inside...

In your original post you listed several different possible results.

The...

SQLKnowItAll (2/6/2012)

---

I don't get it... I believe this is syntactically wrong, but I don't use try/catch blocks much. It seems wrong that your commit is inside the try and...

Don't you just want the sum of counts partitioned by catid?

If at all possible I would highly recommend normalizing this into 2 tables (Category and Fields).

Not exactly sure what you are asking. Are you trying to find all columns in all databases in a single result set?

Something like this should work for you.

create table #Cols

(

TableName...

Hi and welcome to SSC. In order for us to help you, you first have to help us to help you. What do i mean by that? Post ddl (create...