Oh, yes, sorry. The Oracle server I am trying to hit is at our Corporate offices and are read-only. We cannot create procedures on their Oracle Server. I should have explained that, but I didn't think of it. Sorry!!! I had an Oracle Server here, locally, but it's going away and they gave me...
No, I was saying that it does run on Oracle just fine, but not in SQL Server. SQL Server is where it needs to run. Our Oracle server is going away and I am converting everything from Oracle to SQL :-( What a mess... I just have to break the query down into seperate chunks...bummer!
A-ha - that's what I was looking for.. thank you SQL Sister. I just threw my query into Word and did a character count and it was 8,525 characters without spaces. It's a monster. 8,000 characters?!?!? How weak! ;-)
Nope, not using any variables. The error message I get is:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '
SELECT A.ACCOUNT_NUMBER
,H.HOUSE_KEY
,S.NAME
,S.ADDRESS_1
,S.ADDRESS.
Hey Phil,
Well, what the query would look like as far as single quotes, for example, is this:
select * from openquery(server, '
select * from table.a
where site = ''1A''
and where key in (''AB'',''AC'',''AD'',''AE'',''AF'')
')
Hailey
Hello all,
I have a query that will run perfectly fine in Oracle, but when I put it into SQL Query Analyzer and try to run it I get a syntax error. It used to run fine on the SQL Server, however now I had to update the query and add codes into a criteria's "IN ()" clause. It made the query...
Very cool Ristmo!
I didn't know you could make a gif's background transparent. That would help me out tremendously because I was planning on providing 3-4 differnt color scheme options in my final presentation for this company and the way it is now..I'd have to recreate the jpg's in all of the...
Thanks Ayersart for the feedback! Yes, I have been battling with that image on the main page for some time with this company and unfortunately they REALLY like it and insist on using it. I totally agree and everytime I look at that picture I cringe! You'd *think* they'd want to look...
Alright, I think I got them to look the same in both browsers now...
LAST question... how can I get the whole thing to center in the new one? Instead of all be left aligned on the whole screen?
Thanks,
Hailey
Okay, I took what you all said and came up with a whole new design.
This is the old one:
http://69.93.85.115/hailey/template/Trial.htm
This is the new one:
http://69.93.85.115/NewSite/index.htm
Now, I really do think I like the new one better. It will fit on an 800x600 screen better. Now...
Hi all,
I have an internal website that worked fine yesterday and then all of a suddon today my site is replaced with a page that says:
Under Construction
The site you were trying to reach does not currently have a default page. It may be in the process of being upgraded...
Hey!
Thank you Andy for the suggestions! To fix the screen resolution issue - should I just change everything to a % instead of a set pixel? Will that distort anything?
Also, how else could I lay that content out if I didn't use a table - a <div> tag??
Thanks again!
Hails
oh boy, the url would help eh?
Here it is: http://69.93.85.115/hailey/template/Trial.htm
It's on a temporary site right now until I am finished with it.
Thanks again for the feedback!
Hailey
Hi all,
I have a site that I am working on and I don't think it's flashy enough. I have up what they provided me to publish - which isn't much. I have not started the Map or Contact Us pages yet.
Any ideas on how I can spice this up a bit??
Thanks for the feedback...
Hailey
Very interesting....I turned off all of the ad-blockers I could find and disabled my Norton Antivirus Software and it still gave me the problem. I must be missing an ad-blocker someplace. You guys said that it must be the perfect size .gif for an ad so I increased the pic from the height of 80...
I tried to take out all of the white space before and after the image and it didn't do anything. I tried it on a computer at work and it worked just fine. However, it wont work on my home computer on either Mozilla or IE.
Here is a link to my page...
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.