I am needing to pull a few fields from my database from three different tables:
(Orders, Deposits, Property being joined on a column called gfno that acts as an id number.)
The Orders and Deposit...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22766743.html
Zones:
MS SQL ServerDate Answered: 02/19/2008 Rating: 9.4 Views: 0
I need help writing a stored procedure with the foloowing details
Table Network
Network ID NetworkName
1 DOmestic
2 International
3 Freight
4 CAT
Table Center
CenterID Center...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23094698.html
Zones:
SQL SyntaxDate Answered: 01/21/2008 Rating: 8.4 Views: 0
Situation:
I'm developing a microsoft windows program in vb.net with a "search for information screen".
All data is stored in an sqldatabase and all data is about persons, contactinformation and ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23793766.html
If I have strings with ' and " in them. How can I make sure I can put the string into an SQL query and have the query work?
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10181793.html
Zones:
Visual BasicDate Answered: 07/22/1999 Rating: 7.6 Views: 0
This SQL statement works under Delphi and SQL Server Analiser, but it wont work with ASP. Does anyone know why?
strSQL = "SELECT COUNT("Code") as NumRecords FROM Department"
Error :
Microso...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_10322671.htm...
Zones:
ASPDate Answered: 04/04/2000 Rating: 8.8 Views: 0
I have an Evaluation Copy of SQL Server 7.0 and when I go into the Query Designer of a View and right-click in the Diagram or SQL pane I do not get an option to Change Type. I wish to create a Del...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10640481.html
Hi Experts,
Is it possible to use xtal reports to report data from 2 different databases on the same reports. EG. Have 2 databases in SQL and need to pull information from both to display on a r...
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_10883901.html
In a app I wrote I have an SQL statement that takes an extremely long amount of time to run. I am looking for a way to break out of the query if it takes longer than usual. (The same as if you ar...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20086084.html
Zones:
MS AccessDate Answered: 10/29/2001 Rating: 7.6 Views: 0
Hi , i have a number of results i want to display and was wondering the best way. I'm querying 2 values for example
Where currency=EUR and Name=John
Where currency=DEM and Name=John
Where curr...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20223692.html
Zones:
MS AccessDate Answered: 11/19/2001 Rating: 7.6 Views: 0
Hello,
I need to create a weekly report that only displays data entered during varying Monday thru Friday periods. The table does have a date field. Any tips on writing this SQL statement?
T...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20239126.htm...
Zones:
ASPDate Answered: 11/25/2001 Rating: 7.6 Views: 0
