Try this:

master..xp_cmdshell 'bcp "SELECT [name], [id], xtype FROM sysobjects FOR XML AUTO" queryout "C:\bcptest.rpt" -T -c'

/rockmoose

Sorry, can't help You with the OWC Pivot Control.

At my shop the users only use ProClarity as front end.

We "just" build the cubes...

Yeah, maybe the MDX Query App wasn't built...

Ok,

When you insert into the temporary table you will get something like:

(42 row(s) affected)

Familiar right ?

This is an informational PRINT statement that Sql Server does.

When the ODBC driver recieves this...

I never use sysdepends, sometimes it cannot be trusted.

This script uses sysreferences instead.

And gives the "nestlevel" of the tables. ie the no of tables above a particular table in the...

Some of the more complex business rules You refer to here can be enforced with something called TRIGGERS. These are business rules that apply to a table, not to a...

By the way.. search the scripts on this site:

People say good thigs about this one:

http://www.sqlservercentral.com/scripts/contributions/1005.asp

( sorry for all the messy posts, maybe they will help )

/rockmoose

Very undocumented...

select * from syscolumns where colstat & 1 = 1

Will give the Identity columns

/rockmoose

Hi,

If You want something like this ( for free ):

http://www.ngallery.org/dbdocumenter/demo/

You can go here:

http://www.ericjsmith.net/codesmith/

And use this template:

http://www.ngallery.org/dbdocumenter/

It works. ( 3 hours to download and learn.. )

/rockmoose

Hi,

At the beginning of the proc use:

SET NOCOUNT ON

And the code JP ?...

keeping it on your hard disk just for fun ? 😉

"I think the code should now work for all cases ... Keeping my fingers crossed..."

Test all...

Hey Mean Old Yak DBA !

"every table should have a meaningful business related key to ensure no duplicates can be inserted"

I did not say that this always is the key...

Actually the expression:

EXCEPT({[Call Date].members}, {[Call Date].[20031102] : [Call Date].[20031104]})

Will return more than 4(?) members, it will return all the members execept for {[Call Date].[20031102],[Call Date].[20031103],[Call Date].[20031104]} ( thats all but...

use pubs

select pub_name,1+len(pub_name)-len(replace(pub_name,' ','')) as wordcount from publishers

compute sum(1+len(pub_name)-len(replace(pub_name,' ','')))

--/rockmoose

Hi,

Actually the only book I have read (front to back) is

C.J. Date "An Introduction to Database Systems"

This will give a good theoretical understanding of databases and the relational model.

Apart from...

I examined some Execution plans, and what happens when using union all is that a "Concatenation" takes place.

BOL very helpfully gives this:

Concatenation

The Concatenation logical and physical operator scans multiple inputs,...