Search results for query: *

Thanks, that was it. I appreciate it. Jim Lunde We all agree your theory is crazy, but is it crazy enough?

Thank you both, however my result set needs to include the samp_site_id from the RUN table. So based on your sql, here here is my attempt, but I get a syntax error. SELECT run.samp_site_id, res.con_id, res.value_rptd, res.depth FROM GPL_ADM_GPL_RUN as run INNER JOIN...

I have done many group bys, and I think this is doable, but the depth is messing me up. 2 Tables: RUN --- SAMP_SITE_ID RESULT ------ CON_ID VALUE_RPTD DEPTH I want to find the maximum value reported for each sampling site/constituent combination. No problem when I group by the samp_site_id...

I understand that this is not the best option. I simply didn't know of another. Also, DTS is not the issue because I won't be importing tables from one server to the other, I simply need to reference data from another server. Some records will get copied, but there is much logic that has to be...

I am only dealing with 20 table or less, 2 of which are large 500K recs and 4 million recs, all the rest are smaller (under 10K records). I am not will be moving some records based on rules, but I won't be "importing" entire tables. There will not be hundreds of references, that was probably an...

Just to clarify; All the code I am writing on "apsdev13" currently references the "vlib2" server to retrieve data from the nightly dump. When we move "apsdev13" to production, all the code THEN needs to point to "vlib3" which will be the production virutal library server. Two seperate...

I am well aware of the fact that you don't need to refer to the server IF the data you are referencing is on the SAME server. I said this once, but for some reason it doesn't seem to be registering. I am working on one server (apsdev13), the nightly dump is on a DIFFERENT server (vlib2). It is...

Falcon, you were close, the exec needed to be in parenthesis, then it worked. I used the following (I use a function called getVar to store all my global variables including, in this case, my source server): declare @sql varchar(500) set @sql = 'select count(*) from ' +...

Falcon, I tried your method, and while it printed: select count(*) from vlib2.heis_snapshot.dbo.method It did not execute, I got the following error; Server: Msg 7202, Level 11, State 2, Line 8 Could not find server 'select count(*) from vlib2' in sysservers. Execute sp_addlinkedserver to...

Dennis, I have to reference the server because our nightly dump is on a different server than the server our code is being performed on. I was under the impression that you had to reference the server if they are different, is that incorrect? Jim Lunde We all agree your theory is crazy, but is...

What is the best way to handle referring to dev and production servers without "re-referencing" all your code? I am just starting this project, so I want to do it right. Currently we get a nightly dump of data to another server and database and here is the reference to the method table in it's...

I'm not concerned whether it compiles on mine (although it did), as the dialog control works on my box. It compiled on his new box as well, even though the control is not recognized on the form. The control simply shows up as a white box on his form, while on my machine it is the typical gray...

Yes, I just tried it, and it compiles with no issues. Jim Lunde We all agree your theory is crazy, but is it crazy enough?

Sorry I didn't mention that, they have the same references. Jim Lunde We all agree your theory is crazy, but is it crazy enough?

I have an inherited .mdb with a browse button (common dialog active x) that works on my box, but doesn't on a co-workers new box (it worked on his old one). We are both using XP Professional SP2, and we both have the same version of MDAC. His box simply will not recognize the control (it...

The following returns this error (Syntax error converting the varchar value '10, 12, 15' to a column of data type int). The variables are actually input parameters in a function, and the '10, 12, 15' string is passed in: ---------- declare @appID int declare @qID varchar(100) set @appID = 113...

It is set to automatic. Jim Lunde We all agree your theory is crazy, but is it crazy enough?

We had a power failure a couple weeks ago, and ever since we have had this problem. Our SQL Server is scheduled to reboot itself once a week. It reboots fine, but after it reboots, the MSSQLSERVER service won't start even though it's set to automatic. If we go into the service and RE-TYPE our...

Thank you all for you responses. itchybug, You say you can apply images as textures to objects. If I use an image (which is raster), won't it stay raster? How do you all do logos if you want to combine vector with raster look? Jim Lunde We all agree your theory is crazy, but is it crazy enough?

Forgive me if this is an easy question. I am fairly advanced in Photoshop, but a rookie at Illustrator. Here is my problem. I am working on a logo for a friend in which I need to make a stone block with two letters on the face of the front 2 sides. I was able to use the 3d filter in Illustrator...