I'm just getting started. I've written some SQL code in MS SQLserver 2000's Query manager. There you type out the code and then hit the 'execute the query' button.
I want to type code into Oracl...
http://www.experts-exchange.com/Database/Oracle/Q_20266632.html
Zones:
OracleDate Answered: 02/16/2002 Rating: 7.6 Views: 0
I have two tables with same design
these are the columns
tab1
tab2
id,numof,inttime
I want to pull a report something like this
with data from both the tables
where inttime in tab1 = getd...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20662532.html
Zones:
MS SQL ServerDate Answered: 07/01/2003 Rating: 7.4 Views: 0
Hello,
I have a table with
two columns
one is date_time and other the value
Tabl
Date value
3/14/200412:00:15 75.601962742626981
3/14/200412:00:30 75
3/14/200412:00:45 65
3/1...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20920001.html
Zones:
MS SQL ServerDate Answered: 04/16/2004 Rating: 8.2 Views: 0
I use DTS package to import data from Excel to SQL table.
How can I flag some thing each time a Excel file is imported using DTS .... need to track / check in the table the duplicate records in ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23409035.html
We are having ongoing issues with the performance of one of our applications in relation to a particular function. We found that the stored procedure SP_CONSULTANT_LISTOSREQTS was taking a conside...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23431977.html
Hi
I have a stored procedure that returns many rows as its output. I want to use this SP to populate a second table to record them at a point in time. In this second table I want a unique refer...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23443999.html
Zones:
MS SQL ServerDate Answered: 05/30/2008 Rating: 7.2 Views: 5
Currently I am usng the GetChecksum (See code) method to compare tables in my database. This works really well except sometimes it is difficult to see the changes i.e 1234 in table (A) may be chan...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24255126.html
Currently I am usng the GetChecksum (See code) method to compare tables in my database. This works really well except if a new row is inserted in the middle of one of the tables the result is wro...
http://www.experts-exchange.com/Database/Miscellaneous/Q_24259013.html
I am running a compare tool against 2 databases with over 250 Stored Procedures. Unfortunately th SET QUOTED_IDENTIFIER ON is set in one database and SET QUOTED_IDENTIFIER OFF is in the other data...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24068830.html
Zones:
MS SQL ServerDate Answered: 01/21/2009 Rating: 8.2 Views: 0
If a table looks like this:
Startingrollnumber numberofrolls yardsperroll rownumber
1 10 1 1
11 2 1 2
50 1 1 3
51 3 200 4
54 3 200 5
57 15 100 6
72 5 2...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24708811.html
Zones:
MS SQL ServerDate Answered: 09/14/2009 Rating: 9.2 Views: 0
