NEVER MIND

it's an intermittent bug in DTS

Found a way around it.

quote:

---

it is worth noticing that an UPDLOCK rather

than a HOLDLOCK may save the show. An UPDLOCK is a shared lock, so...

A logical model has no ties to an actual database implementation. Column datatypes f.e. are implementation neutral. A logical model can contain heritage and ISA-relations and so forth.

A physical model...

Sometimes the setting

CONCAT NULL YIELDS NULL

is the culprit.

You can cheeck that setting and wheteher it is set from the connection.

hi bkelley,

the trouble is knowing if a questions are asked AND the answer.

thereby

1 = yes answer

0 = no answer

null = null answer = no question asked

so

3 questions asked...

Hi tc,

yepp thank you, got it, tried it.

However I think yor solution has the same flaw as mine.

How do you differentiate between two questions with check and three questions...

Hi tc,

I think you have a point

scenario

step 1: user fills in some data

step 2: user is presented 2 - 12 questions and answers them with y/n

step 3: program concatenates answers,...

Hi all,

thanks for all opinions.

- simple ASP/VB-code rules out OR-ing and AND-ing

- simple SQL-code rules out bitmask

- since all data are loaded once, no updates, fast inserts not necessary

- number...

Hi Antares,

I must have been unclear again.

What I want are opinions (pros/cons) about storing 2-12 true/false values as either

- 12 bit columns

- 12 char(1) columns

- packing them together in a...

I havent been very clear I realize on my question.

I have to store advices based on answers to questions.

A person can get from two up to twelve questions.

The...

quote:

---

Are you storing preferences or something similar?

---

I am storing yes/no answers to a...

quote:

---

Added, just remembered. The page size is limited to 8060 (which Steve or Brian did an article on exploreing this in detail)....

You can save the drawing as a picture.

For the text you have to create a report.

You can send the data to the SP as TEXT, that way you have 32 MB/GB+? to play with.

http://pueblo.lbl.gov/~olken/X3L8/