I need to select two field that combined make a unique field within a date range. I need a little help with the statment.
Example:
Select Distinct (call_ID + Appointment_ID) From SV301 Where star...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23108579.html
Zones:
MS SQL ServerDate Answered: 01/24/2008 Rating: 8.8 Views: 0
I am doing clustering of 2 nodes in sql 2005 - I having difficulty to understand - how to Create and initialize a logical drive space to contain the quorum drive.
1. Is any software required to...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2321...
I do a 4 table join, but i need to return the count from 2 tables. How do i do that ?
I am needing individual counts from table C and the entire count of the join result.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23220369.html
I have table that I need to copy/import the contents to a second table but need to exclude 1 field that is an autonumber type field.
I'm attempting to use the import task feature but don't see a...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23255551.html
Doing a join and the query is not displaying the data as how i expect when handling missing data - please c attached doc. I have attached the tables and query and how i expect the data to display
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23598566.html
Zones:
SQL Syntax,
...Date Answered: 10/25/2008 Rating: 8.2 Views: 28
Hi,
Why does this NOT WORK:
UPDATE msales set freight = ((unitcost / ((100 - 50) *.01)) * (4 / 100)) * qty WHERE idnum = 1
and this DOES
UPDATE msales set freight = ((unitcost / ((100 - 50)...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2368...
I need to replace the text AddLabelRowHTML to AddLabelRowText in multiple rows that are in 31 different databases. (The databases structures are identical.)
The different database issue is one pro...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23720765.html
I have an update statement that goes through 31 databases to replace text. I have attached a snippet of that statement below. The statement updates a row in one database then moves on to the next D...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23722890.html
I have a temp Table :
Declare @Valid Table (TicketNo varchar (20))
With Values similar to:
0067626819365
I need to run a query on a table:
select * from table a where key in ****key****
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2387...
I am trying to make space on a full C: drive and there are several SQL9tools9_hotfix_kbxxxxxx_sqlrun_sql.msp.log files.
Is it safe to delete them?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2390...
