I tried your solutions but my code still gets stuck. I am using AQT to run my queries and the program will just not respond. Could it be that I have too many sub-queries?
Here is my complete code...maybe anybody sees something else I have done wrong...
Thanks again!!!
CREATE PROCEDURE...
Can you pass parameters with the stored procedure as well?
CREATE TABLE #ProcColumn (
ProcColumn varchar(100)
)
INSERT #ProcColumn (ProcColumn) EXEC [MOAD].[dbo].[usp_SysData_Select] DEFAULT
I have the following (summarized) code:
Select * from dbo.PRSEBA where tfvrnr IN (select tfvrnr from pfftpr where tfsoid = 40)
I am using a tool called AQT to run queries on a MySQL server. The code gets stuck on the IN statement. Does anybody know other code to replace IN ?
Actually my code...
I would like to join to tables. I would like to see all the data from table a and only the data from table f which corresponds with table a. I thought a left join would be the solution but I still get all the data from the two tables. I have read the paper on joins but I know I am doing...
Dear all,
I would like to join two tables. The column to join on is char (8) on one table and varchar (8) on the other. Now I get an error. Does anybody know a solution??
Thanks!
Dorine
Probably my server isn't working then. It look like it is because i dont see errors in my log and the service starts normal. But when i do http://localhost it doesn't work.
But i have spent enough of your time. I'll just play with it some more :-(
Probably my server isn't working then. It look like it is because i dont see errors in my log and the service starts normal. But when i do http://localhost it doesn't work.
But i have spent enough of your time. I'll just play with it some more :-(
I searched the forum but it did not work for me :-(
I installed the Apache server successfully and it works as a service under Windows 2000. I wanted to watch the confirmation screen in my browser and typed: http://127.0.0.1/
Nothing good happened. My browser wanted to go to the internet (which...
Wullie,
The Apache server is up and running as a service. But when i type http://127.0.0.1/ in my browser i cannot see the server screen (a book told me i should see a sort of confirmation screen). I also tried:
http://localhost/
Do you know what i have to do??
Thanks again!!
Hi everybody,
I am very new to apache. I just installed MySQL and i would like to install Apache and PHP to start exploring dynamic internet sites. During the installation of Apache it asked:
Server Name
Domain Name
Administrative email account
Well, i want to install it at home where i don't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.