Just about the most convoluted statement I've producted, but will product the required string in one line, which is the required aim, I believe.

select isnull(nullif('1',isnull(medium_photo,'1')),'') +

isnull(nullif('2',isnull(medium_photo2,'2')),'') + ....etc

Paul Ibison

Paul.Ibison@btinternet.com

What I was thinking was that if it is a one-off, in QA,Query,Current Connection Options, Advanced, you can set the result output format as tab delimited, and copy and paste...

Have a look at DTS. You can easily export to a flat file in any format you need.

Alternatively, if ti's a one-off, you can copy and paste the results from...

There doesn't appear to be a database option to enable this, so I wonder if the statistics are not correct. What happens if you recreate the PK index and statistics?

(DBCC...

To monitor over time, you could run the Profiler and select the Scan:Started event. Add IndexID to the DataColumns and perhaps SQL:StatementStarting as another event so you can correlate index...

This is a SQL 7.0 menu option, and I believe it's only sysadmin fixed database role who has the right, although I'm not sure what actual command is being executed.

Paul...

Just had another thought. If you really want to create a vb dll, depending on your needs, it may be possible to use DTS instead of an extended sp. You...

According to SQL Magazine (http://www.sqlmag.com/Articles/Index.cfm?ArticleID=14261) "The official Microsoft answer is that you can only write them in C. Certainly VB doesn't work.

Also Delphi 4 and 5 will work. Delphi Magazine...

I have seen this before when creating a table with a user defined datatype. The EM showed incorrect lengths at this stage, but on closing the design window of the...

I for one haven't seen this before. Previously I'd created a dummy column and used a case statement to populate it in the select, then used ordered by this dummy...

For my own two pennyworth, I had to pass an 'interesting' interview technique recently. Basically, even though my cv shows 7 passed ms exams, I was asked to take a...

You could try this: run dbcc dbreindex with a specific fillfactor (eg 10%) before removing data. Update the statistics and then look at the size of the data and index....

We had a similar issue, and tackled it using two solutions together:

(a) encrypted sensitive info such as passwords etc prior to entering it into sql server (we used crypto.dll: free...

Not completely sure, but think I understand. Could you have one Execute SQL task which sends the mail. This single task could be pointed to using success/completion/failure steps from each...

Thanks guys. The Table datatype would have been ideal, but unfortunately doesn't support SELECT INTO. However using the following syntax is ok:

SELECT a.* into TblNames

FROM OPENROWSET('SQLOLEDB','server';'user';'password',

'exec xp_myproc')...