Search results for query: *

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

Thanks for that.... Yaa thats true but can this be done using a single filesystemwatcher object. I checkedout .NET help 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...

I am using FileSystemWatcher to monitor File movement in some File folders. Have added some events to handle file/files added to that directory (Created). The directory might contain file with different extensions eg : .txt , .rtf , .doc , .xls I would like the event to be fired only when (...

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

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