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

    Need help in deciding approach to resolve the isse

    Thank you for your replies. Please find my comments below - 1. Cannot use Truncate as we are not deleting all records in the table 2. Cannot use temporary tables in tempDB as we need to retain data till the time user is executing another calculation process. Please suggest. Thank you, Varsha
  2. varshan09

    Need help in deciding approach to resolve the isse

    Hi All, We are developing an intranet based web application which deals with huge amount of data. To explain it better, the application has a calculation process which adds nearly 30 million rows in a table for a user. There can be multiple users accessing the application and performing similar...
  3. varshan09

    Query related to openxml

    I want to store xml in a table. Let's say I have following xml: <Root> <Row> <Col1>Val1</Col1> <Col2>Val1</Col2> </Row> <Row> <Col1>Val2</Col1> <Col2>Val2</Col2> </Row> </Root> Is it possible to use OpenXML to insert each <Row>...</Row> as a single row in table? In the above example I want to...
  4. varshan09

    Need export to PDF feature

    Hi, Can you explain more about web services exposed by sql server reporting services? Also regarding XSL-FO pdf generator, can I get simple example of generating PDF report? Thanks Varsha
  5. varshan09

    Need export to PDF feature

    Hi, We are working to develop one analysis tool which has reporting capabilities. Reports are developed in HTML. we need to add a feature of export to PDf. since reports provide pagination feature and in the pdf we need to show all pages. What are different options for it? Thanks Varsha
  6. varshan09

    typed arraylist versus typed collection

    Hi, Is use of typed arraylist versus typed collection is preferred? I'm using for transferring data from one application domain to other. Please clarify. Thanks Varsha
  7. varshan09

    Encrypted fields in SQL server 2000

    Is there any way to specify any column as encrypted in SQL server 2000? We have the requirement of storing passwords in the table and we want to store enrypted values of the passwords. Any pointers will be appreciated! Thanks Varsha
  8. varshan09

    using xp_cmdshell

    EXEC master..xp_cmdshell 'C:\MSSQL7\Exec\SQL_Install_Script_Migration.bat' This will be one time activity during the installation, so we didn't go ahead with the idea of putting the entire thing in a SQL job. Thanks Varsha
  9. varshan09

    using xp_cmdshell

    Just to you an example, we have many steps as part of data migration - 1. Dropping all constraints 2. Running Create and Alter scripts to change the schema 3. Creating stored procedures 4. Creating all constraints We have created different .sql files to perform these operation, and our batch...
  10. varshan09

    using xp_cmdshell

    Actually as part of the bat file, we are writing in a log file, since it is not writing in the log file, also it is not changing the data as per expectation. Thanks Varsha
  11. varshan09

    using xp_cmdshell

    Hi, We have a batch file which needs to be executed from query analyzer. We are trying to do this using xp_cmdshell. It does not seem to be working. When I run the .bat file through command prompt, it transfers the data and logs the trace in the file, as per expectation. With xp_cmdshell, it is...
  12. varshan09

    Applying stylesheets to a desktop applications

    Hi All, We have a requirement to change colour of all buttons and controls on the form throughout the application. I know we can easily do this in the web applications using stylesheets. Is there anything similar to stylesheets in desktop applications which can be used to change te colour of the...
  13. varshan09

    Schema information of a temp table

    Hi All, We are using ExecuteReader method of the SQlCommand object with the option of CommandBehavior.SchemaOnly. It works perfectly fine to get the schema of the columns in the resultset. I am facing problem in fetching schema information of the temp tables(Created using #temp syntax). It...
  14. varshan09

    MSDE Setup

    Hi, How can I find out that a windows PC already has an instance of MSDE? Our requirement is to include setup of MSDE in the application exe and launch the exe if MSDE is not installed. If it is already installed, we need to skip the process of installation of MSDE on the computer. Any...
  15. varshan09

    automatic updates in a desktop windows application

    Hi, In our case, we need to download it form the customer portal. Will it add additional complexity if download from the portal and run it? Thanks Varsha
  16. varshan09

    automatic updates in a desktop windows application

    Hi, We have a requirement of building a standalone desktop application using windows forms. There is another requirement of applying automatic updates of the application(in case there is any change) on the application. We have seen this happening in the windows media player and Windows XP. How...
  17. varshan09

    One doubt related to @@identity

    How do we save @@identity? I tried this query and it is not giving me any record. INSERT TABLE2 SELECT 'Varsha', Max(col2) + 1 FROM TABLE2 select col1, col2 from TABLE2 where col2 = @@identity here, col2 is not an identity column. Let me know if I'm missing anything. Thanks Varsha
  18. varshan09

    One doubt related to @@identity

    Suppose I have a table A with two colums - col1 (number) primary key and col2(Varchar(100)). If I insert a row into this table. Can we get value of last inserted value in the column col1 of this table using @@identity. As far as my understantding goes @@identity can be used for identity columns...
  19. varshan09

    Structured exception handling over UnStructured Exception Handling

    Hi, Can anybody tell me advantage of structured error handling using Try Catch block over unstructured exception handling? Thanks Varsha
  20. varshan09

    Evaluating Expressions at run time

    We are having a table where we are storing some values and an asociated operator with each value. We will be using the value and the operator along with a comparison value and would like to know the result at run time. For e.g. let's say the entry in the table is: 30 >= and the comparison...

Part and Inventory Search

Back
Top