Search results for query: *

Hello All, I am new to DW. I would really appreciate if someone can answer the following question: In my raw fact table source, I am getting fields such as customer_id, customer_sex, customer_source etc. How do I model this? Do I've 1 customer dimension where I am putting customer_id...

May be it is worth exploring Soundex and join it based on that? For example, if you run the following in a query analyzer, you will see what I mean: select soundex('steve'), soundex('steven') select soundex('vic'), soundex('vik')

I was hoping to get some help. I'm using SQL server 2000 (on Windows 2000 server) I have the following code in my stored proc: SELECT IDENTITY(INT, 1,1) AS excel_row_num, * INTO #dc_raw FROM OPENROWSET ('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)}...

hi guys, a part of my task includes how to retrieve the summary info from all the files in a given folder from the command prompt and create a text file of the format: file_name created_date summary_info (where I've one col for all the information I get by right clicking on the file...

I understand the native connectivity is faster. I am using ref cursors in my Stored Proc and using native driver keeps complaining about something that I don't understand. She gets an error: Query engine error: HYC00... (don't know the full error) when she uses the native drivers. I had her...

Thanks for these links, here is why I need these drivers: I've a CR created in ver 8.5 using Oracle 8i client. Now some other developer wants to convert that report to CR 9 (don't know why). She keeps complaining that something is wrong with my stored procs, but the fact is that she is using...

Hello all, I needed some help, can you please help me find out where I can download Crystal Oracle ODBC Driver 4.10? I tried searching the Crystal CD but had no luck. Thanks in advance, Guran

There are a few other things that you need to check for xp_sendmail which are as follows: -- Makes sure that the profile that will be used to send the mail is part of the local administrators group on the sql server box -- Make sure that the two services: MSSQL service and SQLServer Agent...

Hi All, My problem is that I need to schedule a report once the user passes some parameters from a ASP.NET front end. My company is using Crystal Reports 8.5. I was thinking that I will gather the parameters and somehow use windows scheduler to accomplish this task. Has someone done this? If so...