SQL select command
Hi i hope all doing well, i have a problem with this SQL select command : **************************************************************** SELECT DISTINCT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price, auction_items.auction_item_nr, auction_items.reserv_price, biddings.price FROM customers, biddings, auction_items, items, auctions WHERE customers.customer_nr = biddings.customer_nr AND auction_items.auction_item_nr = biddings.auction_item_nr AND items.item_nr = auction_items.item_nr AND auction_items.auction_nr = auctions.auction_nr AND auctions.auction_nr =7 ORDER [...]
Answer Question
| August 3, 2009 12:51 PM
SQL, SQL commands, SQL Select
Hi i hope all doing well, i have a problem with this SQL select command : **************************************************************** SELECT DISTINCT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price, auction_items.auction_item_nr, auction_items.reserv_price, biddings.price FROM customers, biddings, auction_items, items, auctions WHERE customers.customer_nr = biddings.customer_nr AND auction_items.auction_item_nr = biddings.auction_item_nr AND items.item_nr = auction_items.item_nr AND auction_items.auction_nr = auctions.auction_nr AND auctions.auction_nr =7 ORDER [...]
Answer Question
| August 3, 2009 12:51 PM
SQL, SQL commands, SQL Select
Join Logical files and SQL views
I hear Join Logical files are not supported in SQL DDL. But you have the SQL view instead. The shop I work for wants to use SQL DDL. But they have numerous interactive programs that use join logical files. If views cannot have keys, how on earth are they going to replace the join logical [...]
Answer Question
| July 30, 2009 5:11 PM
DDS, Join Logical file, Logical Files, SQL DDL, SQL View
I hear Join Logical files are not supported in SQL DDL. But you have the SQL view instead. The shop I work for wants to use SQL DDL. But they have numerous interactive programs that use join logical files. If views cannot have keys, how on earth are they going to replace the join logical [...]
Answer Question
| July 30, 2009 5:11 PM
DDS, Join Logical file, Logical Files, SQL DDL, SQL View
SQL Server Database Date Time Values
I am developing a software using Date Time values. i am using SQL server 2000 as the database. can i create a coloumn with only time value or data value. Only datetime is available. how can i eliminate a part of it in the database. when inserting the time values the date part is 01 [...]
Answer Question
| July 30, 2009 4:11 PM
SQL Server 2000, SQL Server database
I am developing a software using Date Time values. i am using SQL server 2000 as the database. can i create a coloumn with only time value or data value. Only datetime is available. how can i eliminate a part of it in the database. when inserting the time values the date part is 01 [...]
Answer Question
| July 30, 2009 4:11 PM
SQL Server 2000, SQL Server database
execute as with synonym
This is a good one, I have a stored proc in database A that first deletes some rows from a table in database A. it then does a delete from a synoym that references a table in a different database. We were trying to use a “execute as” with a windows sql account “domainsrvc” that [...]
Answer Question
| August 11, 2009 3:45 PM
SQL Database, SQL stored procedures, Stored Procedures
This is a good one, I have a stored proc in database A that first deletes some rows from a table in database A. it then does a delete from a synoym that references a table in a different database. We were trying to use a “execute as” with a windows sql account “domainsrvc” that [...]
Answer Question
| August 11, 2009 3:45 PM
SQL Database, SQL stored procedures, Stored Procedures
SQL Error
we need to determine error message:the condition applied to this collectioncontains an ORDER BY without a corresponding TOP clause.
Answer Question
| July 30, 2009 2:44 PM
SQL, SQL error messages
we need to determine error message:the condition applied to this collectioncontains an ORDER BY without a corresponding TOP clause.
Answer Question
| July 30, 2009 2:44 PM
SQL, SQL error messages
SQL Server Profiler’s TextData Column Has NULL And Longest Duration value
My Profiler’s TextData Column Has NULL value and Longest Duration value (100000ms). What could be the reason? Thanks
Answer Question
| July 30, 2009 12:25 PM
SQL Profiler, SQL Server 2005, SQL Server Profiler
My Profiler’s TextData Column Has NULL value and Longest Duration value (100000ms). What could be the reason? Thanks
Answer Question
| July 30, 2009 12:25 PM
SQL Profiler, SQL Server 2005, SQL Server Profiler
Learning SQL Part 2
Is there anything out there that would teach help me to learn SQL dealing with communicating with an AS400 system and using MS Access passthrough query system to bring it into Access but using the SQL system as the communicator? What books or Web sight is available?
Answer Question
| July 30, 2009 9:11 AM
AS/400, AS/400 SQL, Microsoft Access, SQL, SQL Training
Is there anything out there that would teach help me to learn SQL dealing with communicating with an AS400 system and using MS Access passthrough query system to bring it into Access but using the SQL system as the communicator? What books or Web sight is available?
Answer Question
| July 30, 2009 9:11 AM
AS/400, AS/400 SQL, Microsoft Access, SQL, SQL Training
SQL vs RPG
Which is faster? Getting a certain number of records using a cursor with SQL or using native I/O’s SetLL & ReadE?
Answer Question
| July 29, 2009 2:56 PM
SQL vs RPG
Which is faster? Getting a certain number of records using a cursor with SQL or using native I/O’s SetLL & ReadE?
Answer Question
| July 29, 2009 2:56 PM
SQL vs RPG
sql server 2000 how can i make backup 4 file only and restore
how can i make backup 4 file only and restore
Answer Question
| July 28, 2009 2:08 PM
SQL Server 2000, SQL Server backup, SQL Server backup and restore
how can i make backup 4 file only and restore
Answer Question
| July 28, 2009 2:08 PM
SQL Server 2000, SQL Server backup, SQL Server backup and restore
SQL Server Errors
Your SQL server installation is either corrupt or has been tampered with (could not open SQLEVN70.RLL0 Please uninstall then re run set up to correct this problem. This question appears in many web pages, but none offers a straighforward method to answer this problem. Reg cure is not the answer, as I have tried many [...]
Answer Question
| July 27, 2009 2:52 PM
SQL Server error messages
Your SQL server installation is either corrupt or has been tampered with (could not open SQLEVN70.RLL0 Please uninstall then re run set up to correct this problem. This question appears in many web pages, but none offers a straighforward method to answer this problem. Reg cure is not the answer, as I have tried many [...]
Answer Question
| July 27, 2009 2:52 PM
SQL Server error messages
VB 6, SQL Server 2000 & Crystal Reports
i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.
Answer Question
| July 28, 2009 3:54 PM
Crystal Reports, SQL Server 2000, VB 6 EE, VB6
i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.
Answer Question
| July 28, 2009 3:54 PM
Crystal Reports, SQL Server 2000, VB 6 EE, VB6
TSQL error messages
Is there any equivalent to error_message() in SQL2000?
Answer Question
| July 25, 2009 3:35 PM
SQL Server 2000 error message
Is there any equivalent to error_message() in SQL2000?
Answer Question
| July 25, 2009 3:35 PM
SQL Server 2000 error message
Identity Reseed SQL Server 2005
I have the following table create table SubscriptionTrans ( transid bigint identity(9223372036854775805,1), transdate datetime ) Run the below insert script 3 times. insert into SubscriptionTrans select getdate() You’ll get below error Msg 8115, Level 16, State 1, Line 1 Arithmetic overflow error converting IDENTITY to data type bigint. Arithmetic overflow occurred. Is there a way [...]
Answer Question
| July 27, 2009 10:15 AM
SQL Server 2005, SQL Server 2005 (32-bit)
I have the following table create table SubscriptionTrans ( transid bigint identity(9223372036854775805,1), transdate datetime ) Run the below insert script 3 times. insert into SubscriptionTrans select getdate() You’ll get below error Msg 8115, Level 16, State 1, Line 1 Arithmetic overflow error converting IDENTITY to data type bigint. Arithmetic overflow occurred. Is there a way [...]
Answer Question
| July 27, 2009 10:15 AM
SQL Server 2005, SQL Server 2005 (32-bit)
SQL server as data source for OBI EE
hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but [...]
Answer Question
| July 24, 2009 9:35 AM
obi, OBI EE, ODBC, SQL Server 2005
hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but [...]
Answer Question
| July 24, 2009 9:35 AM
obi, OBI EE, ODBC, SQL Server 2005
Formating Sysmessage text
How does SQl Server generate this error message What happens when an error occurs in a User defined Stored Procedure. Which System stored procedure is fired I know that the error messages are stored in “sysmessages” table in “Master” Database – but which system stored procedure calls this table when an error occurs.
Answer Question
| July 23, 2009 8:53 PM
SQL Server 2000
How does SQl Server generate this error message What happens when an error occurs in a User defined Stored Procedure. Which System stored procedure is fired I know that the error messages are stored in “sysmessages” table in “Master” Database – but which system stored procedure calls this table when an error occurs.
Answer Question
| July 23, 2009 8:53 PM
SQL Server 2000
Being notified when a delete operation is performed on SQL Server
How can I be notified of delete operations in SQL Server? Is there a tool out there (or something) that will notify me when a user performs a delete operation, without the user knowing about this activity?
Answer Question
| July 24, 2009 5:31 PM
SQL Server security
How can I be notified of delete operations in SQL Server? Is there a tool out there (or something) that will notify me when a user performs a delete operation, without the user knowing about this activity?
Answer Question
| July 24, 2009 5:31 PM
SQL Server security
Eliminating Nulls in tSQL
If I want to return null values in a query that has “Where Field1<>’test’ is there an option I can turn on? Example: CREATE TABLE myTable(Field1 varchar(25)) GO INSERT INTO myTable VALUES (‘test’) INSERT INTO myTable VALUES(‘test2′) INSERT INTO myTable VALUES(null) GO Select * From myTable Where Field1<>’test’ –Only returns test2 and not the null [...]
Answer Question
| July 24, 2009 2:09 PM
ANSI, NULL, T/SQL
If I want to return null values in a query that has “Where Field1<>’test’ is there an option I can turn on? Example: CREATE TABLE myTable(Field1 varchar(25)) GO INSERT INTO myTable VALUES (‘test’) INSERT INTO myTable VALUES(‘test2′) INSERT INTO myTable VALUES(null) GO Select * From myTable Where Field1<>’test’ –Only returns test2 and not the null [...]
Answer Question
| July 24, 2009 2:09 PM
ANSI, NULL, T/SQL
Web Application very slow SQL 2005
Can I get a detailed information on what are the possible things we can do to identify the performance issues? I had run the SQL 2005 profiler against load test for about 2hrs and captured all the trace. I could see the procedure that runs for various different parameters was consistently taking 9505microsecs at some [...]
Answer Question
| July 27, 2009 8:25 AM
SQL 2005, sql 2005 Performance Issues
Can I get a detailed information on what are the possible things we can do to identify the performance issues? I had run the SQL 2005 profiler against load test for about 2hrs and captured all the trace. I could see the procedure that runs for various different parameters was consistently taking 9505microsecs at some [...]
Answer Question
| July 27, 2009 8:25 AM
SQL 2005, sql 2005 Performance Issues
order of evaluation in DateAdd with multiple expressions
I’ve spent 3 hours researching how order of evaluation would work in this expression. If @BeginTime was 16:45:00 for example, what would be the result of this expression? set @BeginTime = DateAdd(mi,-Datepart(mi,@BeginTime)-Datepart(hh,@BeginTime)*60,@BeginTime )
Answer Question
| July 21, 2009 6:53 PM
SQL Server DateTime, SQL Server Functions
I’ve spent 3 hours researching how order of evaluation would work in this expression. If @BeginTime was 16:45:00 for example, what would be the result of this expression? set @BeginTime = DateAdd(mi,-Datepart(mi,@BeginTime)-Datepart(hh,@BeginTime)*60,@BeginTime )
Answer Question
| July 21, 2009 6:53 PM
SQL Server DateTime, SQL Server Functions
Improving the initial speed of a SQL query
I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?
Answer Question
| July 21, 2009 6:11 PM
SQL queries, SQL Query, SQL query optimization
I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?
Answer Question
| July 21, 2009 6:11 PM
SQL queries, SQL Query, SQL query optimization
