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 Chriss Miller 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. webuser

    Parameters Auto-Expand

    Does anyone know if there is a way to make the drop-downs for parameters in Reporting Services Auto-Expand? Right now, when I select a letter, it does go down to that letter in the list but it does not work beyond the first letter. I am used to drop-downs in Access etc. that allow this...
  2. webuser

    Deploying Report From Visual Studio Does Not Update Some Information

    Thanks. So there is no way around this? It's just pretty annoying, especially for automated deployment purposes... I'm just curious though, when you upload the RDL for the first time, are you saying that the parameter and datasource info is stored somewhere other than the RDL on the server? Do...
  3. webuser

    Deploying Report From Visual Studio Does Not Update Some Information

    If I have an existing report on a Report Server, and I modify the report in Visual Studio, then deploy it, only some of the information gets updated on the server. For example, I changed a report parameter from type string to Date/Time and that got updated on the server, but when I added a...
  4. webuser

    Getting Domain Name in Transact SQL

    Perfect!
  5. webuser

    Getting Domain Name in Transact SQL

    That's great. Thanks! But this returns 2 fields - one for value, one for data. What is the best way to set the value column to a variable? I tried a select from... but it didn't work...
  6. webuser

    Getting Domain Name in Transact SQL

    I need to get the name of the Domain that my SQL Server is in using Transact SQL. Is there a function that does this? Like Select GetDomainNameOfMySQLServer() Thanks in advance!
  7. webuser

    Opening an XML from the Internet and inserting in to a table

    Ok, I guess I can live without the requirement of opening up the URL directly. I can just download the file first, then open it locally from SQL Server. Which brings me to the next part of the question though - can you provide code that will open an xml file (locally), and then parse it and...
  8. webuser

    Opening an XML from the Internet and inserting in to a table

    ...looking for something that I can do directly from a Stored Procedure. For example, I have gotten this code to work: INSERT INTO T(XmlCol) SELECT * FROM OPENROWSET( BULK 'c:\myfile\MyXML.xml', SINGLE_BLOB) AS x What I would like to improve here is the ability to get the file directly from...
  9. webuser

    Opening an XML from the Internet and inserting in to a table

    What is the best way to do the following: I have a URL that contains an XML file. I need to easily take that XML file and put it in to a table in SQL Server. I will know in advance the fields in the XML file and in the table. I have seen some code using OpenXML, OpenRowset etc. but I have not...
  10. webuser

    Clustered Index with multiple columns

    Thanks. That's a good suggestion. I will try it.
  11. webuser

    Clustered Index with multiple columns

    In my example, I mentioned a clustered index on Lastname then Firstname. If I tell you that the application has many many WHERE clauses and/or joins on the first name column, I want to know if an additional index on the First Name column would be helpful or if the clustered index (on Last Name...
  12. webuser

    Clustered Index with multiple columns

    What if the index is on two columns, for example, a last name and then a first name. So on disk, the table would be sorted with all the last names first, and than the first names. Now, what if I had many queries that needed to find the First name for some reason, wouldn't an additional index on...
  13. webuser

    Clustered Index with multiple columns

    I want to know if there is a "Best Pracice" to what I am doing. I have a table with several fields and I know that 2 of the fields should ideally be sorted for best performance, so I added a cluster index that uses both of those fields. What I'd like to know is, do I need to add additional...
  14. webuser

    Embedding Word Document in Reporting Services Report

    Is there any way to embed a Word Document, Excel Document etc. using OLE or some other means directly into a Reporting Services report the way it can be done in for example Microsoft Access? If so, how? And if not, what is the easiest way to accomplish what I am trying to do, and that is - to...
  15. webuser

    Reporting Services and User Name Prompt

    Thanks unclerico! The key was http://servername. I had it under Trusted Sites - when I moved it to Local Intranet, that fixed it!
  16. webuser

    Reporting Services and User Name Prompt

    I don't think I did. It's using Windows Integrated Security. Where do you think I need to do that?
  17. webuser

    Reporting Services and User Name Prompt

    I have a Terminal Services machine which users log in to and then go to my Reporting Services web site (ServerName\Reports). Anyway, for some reason, all users are getting prompted for their UserNames/passwords when they go to the web site. I added the web site to the trusted zone. Also...
  18. webuser

    Source Control in MDB And ActiveX

    This is going to be a hard one but I am hoping that someone out there has experienced this and can help me. I have a .Net user control in a DLL. I have embedded this control on to an MS Access Form and it works fine. The Access form thinks it's an ActiveX control, renders it and I can...
  19. webuser

    "Drop Database" + Close Existing Connections

    Perfect! I will try it now. Thanks!!!
  20. webuser

    "Drop Database" + Close Existing Connections

    Thanks. How would this be done in an automated way, like if the script had to run as part of a build?

Part and Inventory Search

Back
Top