Search results for query: *

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.

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

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

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

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

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.

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.

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

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

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?

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.

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

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

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.

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

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