Search results for query: *

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

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?

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

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.

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

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?

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?

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?

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.

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

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

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

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?

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

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?