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

    Search Stored Procedures

    @GMM 1.) At the time, we were only concerned with SP's but I like your suggestion; makes more sense. 2.) This is true...not too sure of a way around it in SQL. I can do it in C#, but haven't figured it out in SQL....gives me something to work on, lol. @SQLScholar GREAT program....I use it a...
  2. robertfah

    Search Stored Procedures

    This works well on SQL 2008 but not on SQL 2000 as sys.procedures and sys.all_sql_modules do not exist.
  3. robertfah

    Search Stored Procedures

    ...ORDER BY Routine_Name' EXEC(@sSQL) FETCH NEXT FROM LoopCursor INTO @DBName END CLOSE LoopCursor DEALLOCATE LoopCursor SELECT 'DONE' *Note: All our DB's are prefixed with 'SC_', hence the string concatination in the SP. I also tested this on SQL 2000 and SQL 2008.
  4. robertfah

    Accessing .cs variable from .ASPX page

    BTW, I meant to mention that txtWebLogin AND the RequiredFieldValidator are in an EditTemplate of a gridview.
  5. robertfah

    Accessing .cs variable from .ASPX page

    I need to access a variable from my code behind in the .aspx page and it's not working. Here's what I'm trying: .aspx page - RequiredFieldValidator <asp:RequiredFieldValidator ID="rfvEditWebLogin" runat="server" ControlToValidate="txtWebLogin"...
  6. robertfah

    Self Join SQL

    SQLScholar - thanks a bunch, works like a charm!
  7. robertfah

    Self Join SQL

    I've got 2 tables that I need to get data from...my users table looks like this: Users Table ------------- UserID FirstName LastName WebLogin WebPassword Active UserAlternates Table --------------------- UserAlternateID UserID AlternateUserID Users Table Data ------------------ 1, John...
  8. robertfah

    Generate SQL Script to create table and it's data.

    I need to write a method that will take a table name as a parameter and generate the SQL statement for creating and inserting the data. What I'm trying to do is copy a table and it's data to another database but I only need the SQL to do so. Any ideas?
  9. robertfah

    Is Order By that costly?

    PK_Issues clustered, unique, primary key located on PRIMARY IssueID it appears as if that's the only index. Here's the results from DBCC SHOWCONTIG: DBCC SHOWCONTIG scanning 'Issues' table... Table: 'Issues' (530816953); index ID: 1, database ID: 10 TABLE level scan performed. - Pages...
  10. robertfah

    Is Order By that costly?

    ggm, cantor - here's the actual execution plan (or part of it): I am working on the SHOWCONTIG results...
  11. robertfah

    Why won't my SP work?

    Remove the extra '@' symbol from the variable and you should be all set.
  12. robertfah

    Is Order By that costly?

    ...the program which this SP is executed, so I decided to run it in the Management Environment to see what's up. Here's the SQL: SELECT Issues.*, c.CustomerName, l.LocationName, l.LocationShortName, r.RoomName, poc.FirstName + ' ' + poc.LastName AS [POC], g.Name AS [Assigned Group]...
  13. robertfah

    SQL to get user password

    Thanks RTag, but what if this isn't an option for me (it is, I'm just really curious if there's a built-in SP or if someone came up with something to do this)?
  14. robertfah

    SQL to get user password

    I've got a windows app that uses a Crystal Report to show data from our DB. My issue with it is that in code, it requires a Login name and Password for the DB. I do not want to hard-code this info for obvious reasons, so is there a way I can retrieve a password for a specific DB user with SQL...
  15. robertfah

    Any upgrading issues from SQL 2000 to 2008?

    Thanks guys...I ran the wizard and it fould Full-Text searches needed to be changed (but we don't use them so I think this is ok) and a few Keywords that have depreciated which will need changing. What a life-saver this app is. Thanks for the help! Oh and yes, we ran it in our Staging...
  16. robertfah

    Any upgrading issues from SQL 2000 to 2008?

    Pretty much what the topic says...we are preparig to upgrade our SQL Server 2000 to 2008 and was curious if there are any hurdles that I should be aware of?
  17. robertfah

    Show complete exception error

    Kostarsus, Thanks for the help, it pointed me in the right direction. Within the project, if you right-click and choose Properties, then the Publish tab, then Application Files, there's a dialog box that appears. Makes sure to click the "Show all files" checkbox in the lower left corner. The...
  18. robertfah

    Show complete exception error

    I've got some code that stores any errors to our DB and emails us when it happens. Here's the simple call: catch (Exception ex) { if (System.Diagnostics.Debugger.IsAttached) System.Diagnostics.Debugger.Break(); else...
  19. robertfah

    Best approach to this SP

    ...1 record or all records from tables within our DB (Customer(s), Location(s), Room(s), etc.). So for customers, we would have 2 SP's: SELECT * FROM Customers And SELECT * FROM Customers WHERE CustomerID = @CustomerID We were thinking of combining them into 1 and making the parameter...
  20. robertfah

    Select Into Creates HUGE Varchar????? But Data doesn't reflect??

    Ah...yes, didn't take into account for the TRIM functions....now it makes perfect sense!

Part and Inventory Search

Back
Top