Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jimmythegeek

    Group by aggragate issue

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

    Group by aggragate issue

    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...
  3. jimmythegeek

    Group by aggragate issue

    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...
  4. jimmythegeek

    Dynamic From Statement?

    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...
  5. jimmythegeek

    Dynamic From Statement?

    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...
  6. jimmythegeek

    Dynamic From Statement?

    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...
  7. jimmythegeek

    Dynamic From Statement?

    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...
  8. jimmythegeek

    Dynamic From Statement?

    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 ' +...
  9. jimmythegeek

    Dynamic From Statement?

    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...
  10. jimmythegeek

    Dynamic From Statement?

    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...
  11. jimmythegeek

    Dynamic From Statement?

    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...
  12. jimmythegeek

    Common Dialog version issue

    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...
  13. jimmythegeek

    Common Dialog version issue

    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?
  14. jimmythegeek

    Common Dialog version issue

    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?
  15. jimmythegeek

    Common Dialog version issue

    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...
  16. jimmythegeek

    Passing in a where string for "in" statement

    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...
  17. jimmythegeek

    Restart Issue

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

    Restart Issue

    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...
  19. jimmythegeek

    Stone Texture

    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?
  20. jimmythegeek

    Stone Texture

    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...

Part and Inventory Search

Back
Top