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!

  • Congratulations gkittelson 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. 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

    Document Storage - Size

    Hi, It's possible to store the content outside the SQL database, and keep the DB small. We are using a provider to store the content on a external device and works fine! look at http://www.stealth-soft.com Microsoft like's it :-) /Navmen
  3. NavMen

    Remove double entries from Query

    Hi Ian, GREAT Job, I modified it to: select sum(q.Size_MB)as Size_MB from (select distinct PhysicalFile, Size_KB/1048576 as Size_MB from STH_SQLDBSIZE) q And got the toital size of all files. Thanks, Navmen
  4. NavMen

    Remove double entries from Query

    Some message on this query: Msg 8155, Level 16, State 2, Line 7 No column was specified for column 2 of 'q'. Msg 207, Level 16, State 1, Line 7 Invalid column name 'Size_KB'. is a select after From supportd? Thanks, Navmen
  5. NavMen

    Remove double entries from Query

    Ian, When I run this query I got the message : Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'group'.\ When I remove Group By I got the message: Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ')'. Thanks, Navmen
  6. NavMen

    Remove double entries from Query

    Ian, Thanks,this gives the size of only one file. The query: select distinct(PhysicalFile), Size_KB/1048576 from STH_SQLDBSIZE Gives: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\WSS_Content_Partners.mdf 0.08807373 C:\Program Files\Microsoft SQL...
  7. NavMen

    Remove double entries from Query

    Hi, Still a small problem, how can I get the SUM of the Size_KB select distinct(PhysicalFile), SUM(Size_KB/1048576) from STH_SQLDBSIZE This still gives me the SUM of all the files, I need only from unique entries? Thanks, Navmen
  8. NavMen

    Remove double entries from Query

    I found the answer: select distinct(PhysicalFile), Size_KB from STH_SQLDBSIZE solves my problem. Thanks
  9. 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...
  10. NavMen

    Extract name from String?

    Borislav, Thanks for the support it works!! Cheers, Navman
  11. NavMen

    Extract name from String?

    Yep, you are right. This is the list we got from the DB EX:"exMgr"</o=myexchange/ou=first administrative group/cn=recipients/cn=exmgr> SMTP:"'John@hotmail.com'"<John@hotmail.com> EX:"Jac Schmidt"</o=myexchange/ou=first administrative group/cn=recipients/cn=jac>...
  12. NavMen

    Extract name from String?

    :-) last question we have also this string: SMTP:"John McAen"<John_McAen@mymail.local> or NOTES:"Es ter Horst"<notes/IBM/Es > with this current query I got :"John McAen or S:Es ter Horst Can we remove text before the first " (and also the ") Thnx, NavMan
  13. NavMen

    Extract name from String?

    Thnx Borisiav, But the string start with EX:"name"< > or SMTP:"name"< > etc I got now EX:Irma Schmidt . How can I remove the words before the first " Thanks NavMen
  14. 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...
  15. 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
  16. NavMen

    Collect information over the last x days?

    Thanks that works fine! It is mm/dd/yyyy, Slip of the finger :-) What about montly reporting of the tranactions? /Navmen
  17. 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...
  18. NavMen

    Remove charaters from String

    Thanks for the answer, but the ' is still there '"court"OR "judical" OR "case number"' How to remove the leading and end ' from the string. Thanks, Navmen
  19. 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...
  20. NavMen

    Question on INSERT VALUES

    Thanks George, That works!! /Navmen

Part and Inventory Search

Back
Top