bcp to xml
Sun, 18 Nov 2007 16:11:22 GMT
can someone please advise me on the correct syntax to bcp export executing a
stored procedures results to xml
I know it begins
bcp "exe sp_procedure" queryout
but unser on the rest of the syntax
many thanks
...
|
how to cut some character from a string
Fri, 16 Nov 2007 05:30:44 -0800 (PST)
dear sir/madam
can u tell me how to cut an specified no of character form any
string in sql server
for example
string "welcome"
how can I retrive the string "wel" from this string
I m using database SQL Server
Please help me
Thanks in Advance ...
|
Fact Table design question
Thu, 15 Nov 2007 13:59:21 -0800 (PST)
Can a degenerate dimension act a a primary key in a fact table when a
composite of the foreign keys (linking to dimensions) doesnt form a
unique key?...The fact's granularity is at the line level and
aggregating is not an option...
example.
service order (DD) service line(DD) part number (FK) employee id ...
|
creating a partition table in developer edition (2005)
Sun, 11 Nov 2007 11:34:32 -0000
Hi Guys,
I have 2 environments i work on , one is SQL server 2005 enterprise
edition and the other is developer edition (both with Service Pack).
i have a scripts creating a partition table who runs well on the
Enterprise version but when i run it over the Development server it
does nothing (it doesn't fail an ...
|
Median MDX function
Fri, 9 Nov 2007 21:08:00 -0800
Hi,
Has anyone used this function before?
Sample data:
Sales table:
ID Region_id Date Invoice# Amount
1 1 20070101 00001 100.00
2 1 20070201 00002 200.00
3 1 20070301 00003 300.00
4 2 20070101 00004 500.00
5 2 20070101 00005 400.00
6 2 20070201 ...
|
Fact table changes
Fri, 9 Nov 2007 11:19:58 -0800
Our data mart is medical based type of subjects.
Recently; the government changed how some "hours" of service could be
provided to certain people. The "hours" value is stored in a Fact table.
So for example; Client XYZ used to have 50 hours; it may have 63 now.
So I see how easy it would have been to make ...
|
SQL 2005 Analysis Services and data encryption
Wed, 7 Nov 2007 14:04:04 -0800
We've got a database which contains encrypted data. To encrypt and decrypt
the data we use 3DES algorithm which is encapsulated into a C# assembly. How
do we incorporate this algorithm into SSAS? We SSAS as the backend for the
reporting services so it's important that reporting services sees the data
in decrypte ...
|
|
|
How to start learnig datawarehousing?
Wed, 07 Nov 2007 02:21:28 -0800
I have worked with integration services and reporting services in sql
server 2005 and I am willing to learn datawarehousing, but how to
start?
...
|
Newbie question
Mon, 5 Nov 2007 20:26:00 -0800
hi,
I am interested in building a DW for my company. As usual, we have 4
different systems which holds different applications. I would like to know
what is the first step of buidling the DW? Retrieve the columns / data that
we need? Any good link to view?
Thanks so much
Ed ...
|
Parent-child dimension related to fact table
Mon, 05 Nov 2007 12:13:13 +0100
is it possible to use a "regular relation" to connect fact table to a
parent-child dimension?
thanks ...
|
