Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gbaksh

    How to model Fact/Dimension

    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...
  2. gbaksh

    cross matching two tables

    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')
  3. gbaksh

    Permission problem with OPENROWSET

    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)}...
  4. gbaksh

    how to find file's summary information on command prompt

    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...
  5. gbaksh

    Where to download Crystal Oracle ODBC Driver 4.10

    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...
  6. gbaksh

    Where to download Crystal Oracle ODBC Driver 4.10

    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...
  7. gbaksh

    Where to download Crystal Oracle ODBC Driver 4.10

    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
  8. gbaksh

    Can normal users exec xp_sendmail?

    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...
  9. gbaksh

    Running a report on command prompt

    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...

Part and Inventory Search

Back
Top