I would recommend not using the local copy and always use the online copy anyway. There are frequent changes and updates to the documentation and your local copy will not...

What is the datatype of your new column? I suspect it is another nvarchar(255). Please use the proper datatypes. You have datetime information put it in a datetime column.

Look at...

You are getting that error because some value in one of your fields is larger than the field size in the temp table. It is one of the most frustrating...

As was pointed out previously you need to help us help you. That means it makes it a LOT easier for us if you post ddl (create table scripts), sample...

I think you would be fine with a try/catch that handles the whole "batch" and you probably want XACT_ABORT ON.

You should probably read up on distributed transactions and MS DTC.

Here are a couple links to get started.

http://msdn.microsoft.com/en-us/library/ms188386.aspx

http://msdn.microsoft.com/en-us/library/ms190773.aspx

I can't emphasize enough the importance of testing this thoroughly in a...

I would tend to shy away from that kind of approach. You will have add additional where checks to every single query IsDeleted = 0

Now you will need an additional...

Hi and welcome to SSC. It is customary to provide ddl (create table scripts), sample data (insert statements) and desired output based on your sample data when posting questions. I...

mmiller 85218 (2/6/2012)

---

Sean Lange (2/6/2012)

---

Pretty sure you can handle the counts now.

As to getting the resultset of all possibilities...

What do you want that to look like? I know it was...

J Livingston SQL (2/6/2012)

---

I think there's a small issue with the math. Using factorial would work for permutations (i.e. the orders of the colors matter), but is not right...

Pretty sure you can handle the counts now.

As to getting the resultset of all possibilities...

What do you want that to look like? I know it was just assigned to you...

mmiller 85218 (2/6/2012)

---

Well, they want a count of all total possibilities...with that, i can apply the factoral...

Jing that will work but I would take either of the two Jeff suggested. My first choice would have been EXCEPT if only because it is VERY easy to read....

Like I said getting the actual numbers is fairly straight forward, getting that data out of sql is a whole new beast.

It has been a long time since I was...

This what you mean?

create table #Cols

(

DataBaseName varchar(128),

TableName nvarchar(128),

Columnname varchar(128),

xtype tinyint,

length int

)

EXECUTE master.sys.sp_MSforeachdb 'USE [?]; insert #Cols SELECT DB_NAME(), obj.Name AS TableName,col.Name AS ColumnName, col.xtype, col.length

FROM Sysobjects AS obj

INNER JOIN...