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: *

  • Users: NavMen
  • Content: Threads
  • Order by date
  1. NavMen

    Add image type to SharePoint Picture Library

    Hi, I'm trying to add a new Image type to the Picture Library. I like to add a .dng file to it and also to generate a thumbnail view voor this image. How is this done for the .JPEG files and is it possible to do tis with other images which are not in the default list. .DNG = adobe digital...
  2. NavMen

    Remove double entries from Query

    Hi, I try to get only one row from a table, when I run “select PhysicalFile, Size_KB from SQLDBSIZE” I get all the physical file locations: C:\Program Files\Microsoft SQL Server\MSSQL. \MSSQL\DATA\WSS_Content_Partners.mdf C:\Program Files\Microsoft SQL...
  3. NavMen

    Extract name from String?

    Hi, I'm trying to extract from the following string only the name: Irma Schmidt String from the DB: EX:"Irma Schmidt"</o=myexchange/ou=first administrative group/cn=recipients/cn=irma> And when I'running the query I got 1000 mailaddresses from the DB and I like only the first 10. Thanks...
  4. NavMen

    Update Table problem!

    Hi, I try to update a table with the following query, the ShPath string is coming from a external source UPDATE SHARES SET group='0' WHERE servername='SRV01' and ShPath = 'C:\USERS_100\' But the ShPath has the entry C:\USERS_100 how can I remove the \ behind the C:\USERS_100\ Thanks, Navmen
  5. NavMen

    Collect information over the last x days?

    Hi I try to collect all tranactions of today with the following query and that works fine, but now I try to get information from the last 7 days and I don't get it to work. select * from STH_POL_REPORT where date = CONVERT(varchar(30),getdate(),101) Date field format is: 02/28/2008...
  6. NavMen

    Remove charaters from String

    Hi, I'm trying to remove some characters from my text string below, with Right I can remove the word CONTAINS(', How can I remove with the same query the characters ') on the end of the string. CONTAINS('"court" OR "judicial" OR "case number"') select Right(POL_QUERY...
  7. NavMen

    Question on INSERT VALUES

    Hi All, I'm trying to put this String: [COLOR=red]CONTAINS('""*aco"" NEAR ""*EVIN""')[/color red] into a table. Using: Insert Into POL_POLICY(POL_QUERY) Values ('CONTAINS ('""*aco"" NEAR ""KEVIN""') ') Doesn't work, what must I do to get it right....!! Maybe it is easy but I don't see it...
  8. NavMen

    Strings in Regex??

    Hi, How can I remove a part of a string, what I try to do is removing the ($dir1) C:\eval form the string $filename example c:\eval\new document.doc. And when there is a sub folder I like to display \Folder\New document.txt. without the c:\eval The following script gives me already a lot of...
    • NavMen
    • Thread
    • Replies: 5
    • Forum: Perl
  9. NavMen

    Use of uninitialized value ??

    Hi, When I run this Perl script from an other directory then the C:\EVAL it will shortcut all the files in the C:\EVAL directory (not checking the last access time). Running the Perl Script in the C:\EVAL directory everything works fine. I got the error “Use of uninitialized value in...
    • NavMen
    • Thread
    • Replies: 2
    • Forum: Perl
  10. NavMen

    Removing characters and change \ to \\ in a string

    Hi, I’m trying to get information from the SQL server and with this information I like to create directories on a Windows Server share. The following script works fine except the creation of the directories on the Windows Server share is not working...
    • NavMen
    • Thread
    • Replies: 2
    • Forum: Perl
  11. NavMen

    Extract information between Characters

    Hi, I’m trying to extract some information from a stored message in the SQL database, the message looks like: Info –I : Message Text [windows event xxx] I like to extract the information between the “:” and “[“ the query I created is as follows: Select substring(message,9,500) as 'Message'...
  12. NavMen

    Average problem

    Hi, Can some help me with the following problem I’m trying to create a query which gives me the Average for a day? I created the next query, but it’s not reporting one Average value. ---------------------------- SELECT drive, round((cast((avg(sessions)) AS DECIMAL(10,0))),2) as 'conn', rate...
  13. NavMen

    Retrive command line output into Perl (with spaces between words)

    Hi, I try to create a perl script which execute a command and to receive the information (output) from a the command into variables of perl and to store them in a database. Works fine! Except when there is a space in the output, like name:”VSS Data” this generate a problem in storing the...
    • NavMen
    • Thread
    • Replies: 4
    • Forum: Perl
  14. NavMen

    Calculate running time (start and stop = duration)?

    Hi, Can someone help me with the following: We like to calculate the time (duration) between Start time and End time of a process, we created two tables with the names “sscreate1” DataType=datetime as Start Time and “sscomp1” DataType=datetime as End Time. I have no idea how the SQL queries...
  15. NavMen

    GETDATE() - Yesterday or before

    Hi, I'm using the following statement for reporting information on daily basis: convert(char(10),GETDATE(),101) = convert(char(10),sscreate1,101) But, how can I report information sinds yesterday or 12 days ago with the GETDATE? Thanks, J

Part and Inventory Search

Back
Top