Hi, I need to save a 6000-character-text data in a field. I see that length
of varchar is 8000. "The value you entered is not consistent with the
datatype orlength of the column, or over grid buffer limit" ! This is the
error message when ever I try to save. Could you please help ...

I want to execute dynamic generated dmx-ddl
from tsql. How to do that?
Openquery doesn't work, because "create mining structure..."
does not return result set.

I am familiar with SQL 2000's Export wizard in terms of exporting data to a
csv or a text file.
Is there any way to export more than one table at a time, though?
childofthe1980s

How can I select 'table name' in select clause if I use UNION ALL?
Example:
select * from table1
union all

   Sorry for a beginner question, I have one table with demographics,
I have another table with sales. I want to figure out which
demographics most likely result in a sale. Now, as an input it seems
to only want to use just one table. Can I use a view, which will

I have data in a vertical format, that I want to un-normalize into a
Horizontal (single-row-per-person) format to make it easier for users to
query on. (data/queries abbreviated for the sake of efficiency and not
boring the heckout of anyone reading):

How can I assign the value of zero '0' to the 'empty string' result of the
count() function? Currently I can only count the res.id's that exist, but I
want the count to equal 0, for the one's that don't exist.
Heres a segment of the code I have so far, and it's not working.

I need your help to sove this problem.
I have a table Customers_Bal containing the following Information:
Date               Balance
01/01/2007     1000

I have C# code that uses the Microsoft.AnalysisServices namespace to
create OLAP databases. I can see the databases in C:\Program Files
\Microsoft SQL Server\MSSQL.2\OLAP\Data. How do I open them with BIDS?
Since I don't have a VS project, I can create a new one in BIDS but