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

    multi table query joins

    Hello, I have reading about queries involving more than two tables. But I am still confused. Suppose I have 5 tables A,B,C, D and Q I have already joined A,B,C,D. Q can be joined to A, B or C ( has their foreign keys) . How do I decide whether to join Q to A,B or C? Similarly, will the...
  2. SQLnewcommer

    Tables

    Hello, I need to read a table from a file(maybe in Excel) and display it in my VB application. I need to be able to read the values in the table too during runtime. What would be the best way to do this?
  3. SQLnewcommer

    Compiling Help files?

    Hello, I have been trying to create a help system for my interface. But I am having a hard time compiling. I have tried downloading both Microsoft HTML Help Workshop and Microsoft Help Workshop(I think this is the same as WinHelp). But I just can't get the files to compile. I have been using the...
  4. SQLnewcommer

    Creating diagrams using SQL?

    Sorry so many questions but how do you "drill down to the database". There is a tree like structure to the left but it is empty.
  5. SQLnewcommer

    error?

    I would like to insert information about errors that occur in SQL (when creating tables and inserting into tables) into a table. I would like to do this automatically, that is , every time there is an error , information about it should automatically be inserted into a table. Any suggestions on...
  6. SQLnewcommer

    Discretize data?

    Hello, I have a table with lesson times, and client no which I extracted from another table. The lesson times are in terms of minutes. How do I group the lesson groups into hours? Like 7 - 8 pm, 8 - 9pm etc?
  7. SQLnewcommer

    Metadata?

    Hello, I need to create a metadata table for a data warehouse. As soon as an error is discovered the details about the errors and the number of errors need to be inserted into the table. Any advice on how to do this?
  8. SQLnewcommer

    Creating diagrams using SQL?

    Thanks for the info. But can you give me more details on how to access the Server diagram? I have finished creating and populating my data warehouse. So is the Server diagram automatically created? How do I access it?
  9. SQLnewcommer

    Queries with Cube operator?

    Hello, I need to make queries using the Cube operator in my database(using T-SQL). Could you please give me some advice or lead me in the right direction, or give me some examples? Thanks.
  10. SQLnewcommer

    Creating diagrams using SQL?

    Hello, I need to create a hard copy of my data warehouse design for a report. I looked at the following website and really like the way they did it.. But I do not know how they did it. Could you give me some information about it. http://www.windowsitpro.com/Files/09/8563/Screen_02.gif If you...
  11. SQLnewcommer

    Date dimension?

    I meant dateadd('qq',@x,'12/31/1999')
  12. SQLnewcommer

    Date dimension?

    Hello, I am trying to create a date dimension. I have no idea where to start but I just gave it a try and came up with the following code. I am going to put this in a while loop . and I have declared @x as an int. insert into Date_source values dateadd('qq',1,'12/31/1999') set @x = x...
  13. SQLnewcommer

    Error?

    Hello, I am creating a data warehouse using T-SQL. I am getting the following error: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error Any idea about how to solve it?
  14. SQLnewcommer

    Server: Msg 2627??

    So you mean if I have something like PK attribut1 attribute 2 10 abc qrs 20 xyz tpr I am trying to insert another row like 10 hhg stt? I just checked my values and I didn't do that. But I did notice that I have some rows like PK attribut1 attribute 2...
  15. SQLnewcommer

    Server: Msg 2627??

    Hello, I am working on an assignment and I got an error message. Server: Msg 2627, Level 14, State 1, Line 1 Violation of PRIMARY KEY constraint 'PK__Supervisor__5A254709'. Cannot insert duplicate key in object 'Supervisor'. The statement has been terminated. How do I solve it?

Part and Inventory Search

Back
Top