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.

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

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

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?

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

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