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 Mike Lewis 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. willdevelope

    BGP Routing

    How can you verify the next route the router will take if you shutdown one of the routers. By the way there is no diagram to look at. It's OSPF routing protocol.
  2. willdevelope

    What server could be used to handle 500 Mac user?

    The server will have to host the username and passord for account purposes. The network will be used for School system and they are only allowed to use mac in the classroom.. This is from the ground up project.
  3. willdevelope

    What server could be used to handle 500 Mac user?

    Ok,What would is the recommendation to set up 500 enduser mac enviorment and what server to purchase? What should the infrastrure be and bandwith recommendation. The site will heavily use online training, such as live streaming
  4. willdevelope

    What server could be used to handle 500 Mac user?

    I come from windows enviroment and not really familiar with Mac,but a colleague would like to know, what server to purchase to setup for 500mac users for streaming video and youtube? Any advice would be appreciated
  5. willdevelope

    messagebox

    How do I create a message box to pop up, if text box is empty once clicking on button using asp.net C# 2. How do I click on command button and display whatever date typed in text box to display in message box back to the user in asp.net C# I am rookie so any extra advice would be helpful...
  6. willdevelope

    Create default unique id such as U82300001 etc

    How do you create unique identifier such as U82300001 ,U82300002 and U82300003 etc to autogenerate for each row ?
  7. willdevelope

    Get current user

    This script returns login information from the default trace created in SQL Server 2005. When the sys.server_principals data is null that would mean the login is allowed via a Windows Group. sys.traces provides the information for the default trace such as the file path and the max files...
  8. willdevelope

    where do you purchase license for 2005 ?

    Where do you go to purchse a legal license for 2005 ?
  9. willdevelope

    SQL SERVER 2005 DB Encryption

    Try these guys out http://www.vormetric.com/ They provide support on how to encrypt your database and any technical question on problem you may have while using the software
  10. willdevelope

    Compare Two Database Fields On Report

    I am new to crytal a rookie How can I compare two database field on report, such as OnSite and Offsite Example if onsite don't match offsite alert "don't match" Thanks in advance
  11. willdevelope

    function date

    select * from table where table.ReadyDate= dateadd(day,-day(getdate( )) 1,getdate( ))
  12. willdevelope

    SQL View with TOP Clause

    Well since you want the max for a specific column try the Max function and leave everyhting else the same Example Max(activitynumvber) as Highest,***Just replace the field***
  13. willdevelope

    Help with Where Clause

    Thanks alot Mr.Mastro your SQL FU IS VERY GOOD...
  14. willdevelope

    Help with Where Clause

    Well guys, once i ran the code it did not give any error but no data was returned..
  15. willdevelope

    Help with Where Clause

    How do I write where clause to compare first two character in two differect table to show the first two don't match ***If Storage first two letters don't match Quantity please show first two letters only Ex The data tables quantity and storage Quantity.unit Storage.area CS...
  16. willdevelope

    Error converting data type nvarchar to numeric.

    **The query will select the data fields find if I comment out the where clause but I am trying to compare two fields LOCATION_INVENTORY.onhandqty and ITEM.STORAGE_TEMPLATE if data LOCATION_INVENTORY.onhandqty don't match ITEM.STORAGE_TEMPLATE show me data.But if i remove where clause it will...
  17. willdevelope

    Locate Maximum Date

    Just for the record, anybody looking at this code there is only one little flaw the parameter @Warehouse_Id was not assign a datatype such as datetime or varchar .But the logic is on point example @Warehouse_Id as varchar
  18. willdevelope

    Locate Maximum Date

    Thanks alot gmastro, once again you have save the day
  19. willdevelope

    Locate Maximum Date

    Product Warehouse_ID product_enter_dt 1 2008-07-01 1 2007-07-01 2 2008-10-01 Inventory Warehouse_ID Inventory_Enter_dt 1 2002-01-01 1 2009-05-01 2 2007-11-30 Store Warehouse_ID Store_Enter_Dt 1...
  20. willdevelope

    Check If Record don't exist give error message or msgbx

    Here is my select statement and it works. Just don't know how to validate if data don't exist by displaying mesage <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:PyxinventoryConnectionString %>"...

Part and Inventory Search

Back
Top