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!

  • Congratulations strongm 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. ajacode

    IS VB Net Robust enough for Heavy Web load

    Hi All, I'm sure somewhere on MIcrosoft.com the marketing guys have their spin articles but I have a client pushing back on using VB .Net versus (C ++) or C # Has the new version of VB .Net overcome that old issue with the non compiled Version 6 ? Here's their question...
  2. ajacode

    Recover Old Exchge 2000 MDBDATA files

    What is exmerge ? I haven't heard of it before. Is it a utility within exchange? Thanks for your reply Z
  3. ajacode

    Recover Old Exchge 2000 MDBDATA files

    Do you know how to retrieve valuable data stuck in some Exchange 2K data files recovered from the Exchgsrvr\MDBDATA fiolder on a crashed Win2003 SBS Server. I have since re-installed SBS2003 and Exchange 2000 but I can't seem to see any documentation to see if I can recover the files. I dare...
  4. ajacode

    Cross Tab in SQL 2K ??

    HI Zhavic, Here's what I came up with using your structure and my real table names..... +++++++++++++++++++++++++++++++++++++++++++++++++++++++ SET NOCOUNT ON DECLARE @tab TABLE (Field VARCHAR(128), Value VARCHAR(250) ) DECLARE @sql NVARCHAR(900) DECLARE @FolderID VARCHAR(50) SET @FolderID...
  5. ajacode

    Cross Tab in SQL 2K ??

    Zhavic , IN this Segment SELECT @cSQL = @cSQL + 'SELECT ''' + [name] + ''' AS [ID], ' + [name] + ' AS Color ' + 'FROM dbo.' + @cTablename_A + ' AS [A] ' + 'WHERE [A].' + @cTable_A_ID_column + ' = @ID '...
  6. ajacode

    Cross Tab in SQL 2K ??

    This looks promising I'll let you know how it comes out Thanks for the Quick reply, Zhavic
  7. ajacode

    Cross Tab in SQL 2K ??

    How to Update from Single Row/Many columns to Single Column/Many Rows In SQL Server2000 I want to try to create a stored procedure that uses the following select statement which pulls all the column names from a single row in a table: We'll Call it A SELECT name FROM syscolumns...
  8. ajacode

    How to Update from Single Row/Many columns to Single Column/Many Row

    AFter Further Review.... I'm Not sure I stated my Problem correctly Here's Table A Folder ID Apples Peaches Plums _______________________________________ 000011 Red Yellow Purple I want to insert it into this table B FruitID Color __________________________ Apple Peaches Plums and End...
  9. ajacode

    How to Update from Single Row/Many columns to Single Column/Many Row

    In SQL Server2000 I want to try to create a trigger or at least a stored procedure that uses the following select statement which pulls all the column names from a single row in a table: We'll Call it A SELECT name FROM syscolumns WHERE [id] = OBJECT_ID('dbo.A') To create a...
  10. ajacode

    Starup Configuration Utility in XP ???

    Thanks Crobin, This forum shoops the pants off the MS newsgroups.. Quick replies, good advice and e-mail notification to boot.. Thanks Again AJACode
  11. ajacode

    Starup Configuration Utility in XP ???

    Anyone know how to get the utility in XP that lets you choose which drivers will load and how startup will run. I remember it as a graphical applet with listings of startup dlls and applets and a checkbox for each to deactivate them. I think it's here in XP but maybe I am remembering something...
  12. ajacode

    STrange Error Message in VB6

    Thanks to you both, In the end I think we found it to be a permissions issue. When I was working on my machine physically at my desk everything was OK. When I used a VPN and remote desktop connection I got the error. I found it rather strange but the system sees me as a "different" user...
  13. ajacode

    STrange Error Message in VB6

    RunningVB6 (SP5) on WinXP Pro SP1 I am trying to run the active X we created which had run before and has all the updated files to run but I try to run it from my IDE and I get the error message System error &H80004015(-2147467243). The class is configured to run as a security ID different...
  14. ajacode

    Hyperlink Formula ?

    In Crystal 8.5 using the ActiveX Viewer on IIS5 We have a hyperlink which we wanted to use but make it non specific for the server We have tried Localhost but that does not seem to work Hardcoding and Naming a specific server works https://tcbserver8/TCBWorks/initial_contact.asp?CaseID=...
  15. ajacode

    Universal Hyperlink How To??

    In Crystal 8.5 using the ActiveX Viewer on IIS5 We have a hyperlink which we wanted to use but make it non specific for the server We have tried Localhost but that does not work This works https://tcbserver8/TCBWorks/initial_contact.asp?CaseID=3535.00 This does not...
  16. ajacode

    SQL 2K is Left Join same as Left Outer Join?

    Thank You for each of your responses. Yes Inner Joins are ONLY = records, and Indeed you have convinced me Left Join and Left Outer Join are the same syntax. Thanks Again. AJ
  17. ajacode

    SQL 2K is Left Join same as Left Outer Join?

    In the SQL Server TSQL does LEFT JOIN return the same records as LEFT OUTER JOIN ? If not what is the difference ? Thanks, AJ
  18. ajacode

    Group Selection Formula using Parameters ??

    I am trying to limit a Group to show records with a sum which falls within a range. The range is part of the stored procedure and filled in by the users but I keep getting an error message stating "A number or Currency Amount is Required HERE" Right Before the Parameter...
  19. ajacode

    What is Midnight of a NEW Day in SQLServer ?

    Thanks Everybody, This subject as small as it is can generate a number of approaches. I think you for your contributions all.. Happy HolidaysPS My 6 year old can now tell Santa what the proper time for him to arrive <grin> AJACode
  20. ajacode

    What is Midnight of a NEW Day in SQLServer ?

    IS the beginning of a new day in Date Time format in SQL server 2000: A) 12:00:00 AM OR B) 00:00:00 AM ? C) Makes no Difference I have heard that A is actually 12 Noon a nanosecond before the PM cycle since PM is actually 12:00:01 Thanks for the Reply

Part and Inventory Search

Back
Top