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 Chriss Miller 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. ssv45324

    Dell PowerEdge 2950 Base Vs Enhanced.

    Hi Everyone, I am planning on buying a Dell PowerEdge (2950) Base at the price of 1300 with a single processor. I was wondering if i can add another processor and a second hard drive at a later point of time if required. Please let me know.
  2. ssv45324

    IF statement within CASE

    Thanks guys for the feedback. Your suggestions helped me solve the problem
  3. ssv45324

    IF statement within CASE

    Is it possible to use a if statement within case something like select user.f_name, CASE user.l_name WHEN 'xxxxx' THEN IF (user.user_id) in (select vendorcompany.user_id from user, vendorcompany where vendorcompany.company_id = user.company_id) BEGIN user.l_name...
  4. ssv45324

    A better way

    I have a view say peoplesearch which have columns say name, description, age etc.(aggregate of a couple of tables) . Now i have two other tables which will have the addresses of each person in the view peoplesearch. These tables are address and peopleaddress. My goal is to retrieve the city...
  5. ssv45324

    Is this query possible?

    My goal is to change the where clause depending on a variable. For example if @value > 0 my where should be sampletable.column1 = 1 and sampletable.column2 = @value2 If @value = 0 my where should be sampletable.column1 = 1 and sampletable.column2 > 0 I am looking for something like...
  6. ssv45324

    Best way to do this.

    Thanks for all your responses. The rules are as follows. A document is considered to be approved if it has all 1 s in the approval status column. Even if one entry is not = 1, then the document is not approved. A document is considered denied if it has any one of the value as 3.
  7. ssv45324

    Best way to do this.

    Thanks for the reply. But i have aa status of 0(not approved) so if a doc_id has the following entries 0, 0, 1 it will be 1(approved) but thats not really the case.
  8. ssv45324

    Best way to do this.

    I have table like this - ID doc_id approval_status 1 1 0 2 1 1 3 1 3 4 2 1 5 2 1 6 3 1 I would want to write a sql which will give me the doc_id and the approval status like doc_id approval_status 1...
  9. ssv45324

    Conditional constraint.

    My intention is not to change, just to ensure that a column in null when another one is not.
  10. ssv45324

    Conditional constraint.

    I need to make a column not null when a value in some other column is not null. How can i acheive this in SQL?
  11. ssv45324

    Dates in a table.

    Thanks for the response. The application i am talking about is a web application, so the server by default always gets the server date time. My debate is whether the datetimes stored in the table should be the server date time or the client date time.
  12. ssv45324

    Dates in a table.

    Is it a good idea to store local dates in the same table? For example a table can be updated from different time zones. If a table is updated from EST, then the time stored will be EST, if a table is updated from CST, then the time stored will be the PST time. My argument for this, is that it...
  13. ssv45324

    Better Database design?

    Thanks for the responses. jbenson, if i create a seperate table for states how can we handle the issue mentioned by philhege?(Some timezones bifurcate timezones).
  14. ssv45324

    Better Database design?

    Thanks for the response. Why do you think this is a better design than the first one that i had suggested? Not questioning your response, just wanted to understand better.
  15. ssv45324

    Better Database design?

    We have a lot of tables and a couple of those tables are COmpany, Users.(Users are connected to company tables). Now we want to display the time correctly. Since ours is an international application, we need to display the time according to the timezone. So is it a good design practise to add a...
  16. ssv45324

    Joins with 3 tables.

    This is my requirement. I have a table A which has names, a table B which has the statistics of the number of users visting the sites(whose names are in A) and a table C which has the company information. I need to write a SQL statement to get all the names in tableA and the number of times it...

Part and Inventory Search

Back
Top