Viewing 15 posts - 25,231 through 25,245 (of 26,490 total)
Okay, that helps. But to paraphase a bit to be sure:
Contract is being split into Customer, Address, and Contract in the DW.
Is this correct?
Edit:
Also, can a single customer have...
February 26, 2008 at 10:32 am
Matter of preference I guess. I find cte's help me keep the code cleaner actually instead of using derived tables in the FROM clause. Keeps it more like...
February 26, 2008 at 10:22 am
For your perusal, some more code to play with:
create table dbo.RoomData (
Room smallint,
XDate ...
February 26, 2008 at 9:58 am
Based on what I have read, I have another question. How does the OLTP system relate Contracts to Customers since it does not have an apparent FK relationship defined?
Could...
February 26, 2008 at 9:41 am
This may not answer your question, but it may help you figure out what you need to do:
create table #RoomData (
Room ...
February 26, 2008 at 8:52 am
Without giving away company specific info, can you provide a simple schema of how the tables relate in your OLTP database and in your datawarehouse? This will help me...
February 26, 2008 at 8:22 am
May I ask a dumb question first, what is a round robin database?
:unsure:
February 26, 2008 at 8:17 am
Or, as this looks like the database is SQL Server 2005, I'd start with the subquery only. When it returns the appropriate data, turn it into a CTE and...
February 25, 2008 at 1:50 pm
Import the "date" fields (i.e. 100083) as an integer. The following SQL code when run in SSMS will convert the value to a date. You can incorporate this...
February 25, 2008 at 9:59 am
The following is untested. I was out on the pitch all day Saturday and Sunday, and didn't have time to create your tables or convert your data into insert...
February 25, 2008 at 9:15 am
We are trying to help you. If you take the time to read the article I pointed you to, you would see what we need to be able to...
February 23, 2008 at 11:02 pm
I'd like to provide you with more help, but you still haven't provided us with the expected output you are looking for from the query. I am not going...
February 22, 2008 at 9:19 pm
Read this article:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
It will help you figure out what is needed to allow us to help you better.
I realize that for SSIS, some of it may be more difficult, but...
February 22, 2008 at 5:00 pm
All that is missing now is your expected results when the data is queried.
February 22, 2008 at 4:56 pm
You are going to have to show me what you are trying to accomplish. Read this article:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
then following what it recommends and post the table DDL, sample data, and...
February 22, 2008 at 4:33 pm
Viewing 15 posts - 25,231 through 25,245 (of 26,490 total)