Search results for query: *

The app does use ODBC. I have tried tracing through the ODBC administrator however nothing gets logged against the Pervasive database. I did not see anything in the Pervasive monitor utility that showed the actual SQL and the query plan viewer (w3sqlqpv.exe) does not seem to do anything. Is...

Does anyone know if there is a tool like MS SQL Server's Profiler that will allow me to monitor the SQL statements being issued against a Pervasive database? I have both 2000i and 8 of Pervasive if there is a tool with either of those versions. Basically, I want to see what tables and fields...

Terry, Thanks for the feedback. I am using SQL 2000. As for the usage, I am inserting about 500,000 records into the table. I have a couple of insert statements then go on to reference the table several more times. I read that table variables are more efficient and was trying to take...

Try this... SELECT DISTINCT StudentID FROM student_grade sg1 WHERE Grade = 'A' AND NOT EXISTS (SELECT * FROM student_grade sg2 WHERE sg2.StudentId = sg11.StudentId AND Grade <> 'A' )

Thanks for the quick response. I am not sure I stated clearly what I was asking for so please let me elaborate. If I have the following... CREATE PROCEDURE a AS BEGIN DECLARE @mytable TABLE (col_a INT) INSERT INTO @mytable SELECT col_1 FROM any_other_table SELECT * FROM @mytable END...

Is it possible in SQL Server 2000 to create an index on a table declared as a variable. I get a syntax error when attempting to do this. For example... DECLARE @mytable TABLE (col_a INT) CREATE INDEX i_mytable ON @mytable (col_a)