For GROUPS of true-false values you can easily modify the questions while still using bitwise operations. From my example above after setting the Question 2 checkbox to true and several...

Oh - the pattern for the possible values is last value * 2. So the next value in the enum I have listed is Q13 = 4096, and Q14 would...

Ok, I wrote you a sample VB6 app to demonstrate the saving of the questions answers to one field of type int. The app only saves to the registry, but...

Thanks Antares, I have built my own encryption dll that wraps the crypto api's

from MSFT, but I believe I will probably switch to theirs as it supports

signatures, and...

K, then I still suggest using bitwise operations as that is your cleanest solution. Then from VB, C++, etc. you can use the bitwise "OR" and "AND" to assemble them...

Try just raising an Error. When you raise an error the HRESULT of the com call will be set to a non successful error code. The ExitProcess api can be...

My Suggestion is this: If storing the state of settings of some kind, use bit wise comparisons, and store the number as a sql int (VB long).

Tim C.

//Will write code...

Hmmm, if using a numeric data type you will lose all leading zeroes, so that

rules out #2. #3 is not bad, you can use a view or an UDF...

Well I have already found a bug. It runs fine the first time, but the second time you run it the transformation has mysteriously cleared itself. I am unsure of...

If you want I can script the DTS package I created so that you can see it work. I just did not do that as it would be rather large.

Tim...

K, create a package with a sql datasource, and and excel file connection(name the excel connection ExcelOutPut). Create a transform betweeen the two (outputting to the excel file). Test this...

DTS

Tim C.

//Will write code for food

One Windows to rule them all, One Windows to find them,

One Windows to bring them all and in the darkness bind them

In the Land of...

The INSERT...SELECT and getting the identities back out does not exist for SQL Server of any version. This is a problem that many people would love to see a...

Then all you have to do is extend the namespace in Steve's query to include the database name. Ex of a namespace :

DBName.OwnerName.TableName.ColumnName

Tim C.

//Will write code for food

One Windows...

I posted this proc in my contributions section(not approved yet) and it will be available from there if I make any changes / updates.

http://www.sqlservercentral.com/scripts/listscriptsbyauthor.asp?author=59500

Tim C.

//Will write code for food

One...