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

    Using SPQuery to find a particular document in a specified format

    Hello, Can we use query to check if a document library or folder consist a file whose name is in particular format eg: Below are the file name abc 10 Oct 2007.doc xyz 15 Nov 2007.ppt xyz 15 Nov 2006.ppt I would like to use SPQuery to find all documents that were prepared in 2007 (having 2007...
  2. nikhilparchure

    Configuration File Changes for setting Authentication

    Hi all, We have a Web Application/Site that has been hosted on Tomcat. The requirement is to have NTLM authentication on certain confidential documents. These documents would be links on this website. When someone clicks on the same. Windows authentication for this resource should happen...
  3. nikhilparchure

    indexing on 2 fields

    Hi , You will have to creat two seperate indexes for this. So two non-clustered indexed should do the thing for you Cheers Parchure Nikhil
  4. nikhilparchure

    File Exist on a harddrive

    Is there a comand to search if a file exists on local system This should be some system sp I believe. Help appreciated Parchure Nikhil
  5. nikhilparchure

    T-SQL Concatenation Question...

    Hi pz, effectively ((@Date is Null or Date = @Date)) can be more streamlined to make the query look like SELECT Task From Tasks Where LocationID = @LocationID and Date = Isnull(@Date,Date) ... If the @date is null then it makes a self join query which is what you require
  6. nikhilparchure

    Collation Error

    The problem is that the collation setting of the tempdb and the DB you are using or different. Possible Solution 1) Drop and recreate database if small in size 2) use of database default.. Hope this helps Cheers
  7. nikhilparchure

    MAX(somedate) help

    Is this what you are trying to do!!! SELECT its.storeid,OnHandQty,(OnHandQty*rv.price) rtvalue,rv.price,its.itemid,(mcl.descr)subcat,(its.descr)itemdescr,mcl.parentclass FROM StoreItem its JOIN ( Select A.itemid , A.Price , A.effectiveDate as currdate FROM EffectiveStoreItemRetailValue A...
  8. nikhilparchure

    Remove chars from string - current solutions seen are not good enough

    You might want to write a udf which would be generic enough which will do the following steps 1) Loop thru the string for the its datalength 2) Check for each character with the Isnumeric function 3) return when the Isnumeric returns false well for your string it should be '10001blah354'...
  9. nikhilparchure

    MAX(somedate) help

    The SQL is wrong from its first look What you are achieveing by the above is Grouping by items -- > price --> get max effective date for that item-price combination which is not what you require Well I did some sample test as see the need of modifying your derived table query with the below...
  10. nikhilparchure

    Any Script to generate INSERT Statements

    As I kinda recollect , there is a way to do that using a DB access tool DBArtisan I am not using it currently and cannot give you the exact solution. But I am sure that DBArtisan lets you generate insert statements of a physical table to a file. Hope you find this useful Cheers..
  11. nikhilparchure

    Performance Enhancement Permanent Tables,Table DataType and Temp Tab

    Thanks nigel for the coments. Really appreciate it.... something more i would like to ask for Well I know the use of physical table instead of temporary tables speed up the operation but I want some quantifying reasons why they are the latter is slower that the using physical tables.
  12. nikhilparchure

    Performance Enhancement Permanent Tables,Table DataType and Temp Tab

    Hi Guys, We have a application for reporting purpose. there has been a suggestion to use-query-drop permanent tables instead of using temporary tables Or table datatypes. This would obviously improve performance. Yes it does. Although the reports wont be run simultenously hence duplication...
  13. nikhilparchure

    Show one record for multi-line output

    Declare @Client varchar(100) Select @Client = Client from TableName Where A/C No = 29374 and timestamp = min(timestamp) Select A/c No , @Client , sum(Amount) From TableName Group by A/C No The above approach could be used to get the First client name used by the data entry operator...
  14. nikhilparchure

    Show one record for multi-line output

    Select Ac/No , max(Client), sum(Turnover) From TableName Group By Ac/No Could This Help!!! Parchure Nikhil
  15. nikhilparchure

    How to loop troo records in stored procedure

    Pls use the cursors if no other solution is available. very much resource hungry Use of #temp tables to loop through the records. Also solutions are always available Nikhil
  16. nikhilparchure

    Show one record for multi-line output

    Yaa we need a sample input to analyse this. Beware using direct DB values into such forums eg : Client Name , Server Name ... could land you into trouble. Parchure Nikhil
  17. nikhilparchure

    FileSystemWatcher Problem

    ...with regards to this , it says that the filter property follows "dir" comand format With that respect if I want only .txt and .rtf files to be displayed than I use the [dir *.txt , *.rtf ] comand So if the use the same in the Filter property it should work But it doesn't Thanks anyways Nikhil
  18. nikhilparchure

    FileSystemWatcher Problem

    ...has a property FileSystemWatcher.Filter = ".extension" to watch particular extension. To Watch all the files FileSystemWatcher.Filter = "*.*" which would filter the files that the watcher might be screening. But I would like to have Single Watcher to monitor two type of files eg: .rtf Or...
  19. nikhilparchure

    How to display date/time value in a datagrid

    This is something the I have encountered also. Well I am not sure , but if you increase the width of the column enugh to occupy the required datetime the (date + time) both gets displayed on the grid. Hope this helps Regards Nikhil
  20. nikhilparchure

    how do you restrict resultset to return only one row?

    Another way Set RowCount 1 --- Your Select Query Set RowCount 0

Part and Inventory Search

Back
Top