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

  • Users: Nsan
  • Order by date
  1. Nsan

    Looping thru values returned from a database

    Looping thru values returned from a database and passing the values to a method. I need to retrieve names(5000) from a database and modify each value by passing it to a function then that returned value needs to be updated in the database. So far no luck. Dim ConnString As String =...
  2. Nsan

    LATEST DATE

    Great information.. Thanks..
  3. Nsan

    LATEST DATE

    Using SQL Server 2005 I need to return data based on the latest(highest) date value in a column and 7 days back. Any help would be great.
  4. Nsan

    Running code

    Is there to capture all running code to a file?
  5. Nsan

    Substituting a zero value

    Thanks for the suggestion, but no change Same results Brandon 0 Greg 0 Sam 5 Chris 0 Steve 2 Jordan 0
  6. Nsan

    Substituting a zero value

    I run the following: select custname, count(custid) as CUST Produces the following: Brandon 0 Greg 0 Sam 5 Chris 0 Steve 2 Jordan 0 How can I substitute the zero values for a blank space? Thx
  7. Nsan

    datalistitem

    I have a datalist that contains a listbox and a label. I need to count the number of values in the listbox and display that number in the label. Nothing that I have done has worked.
  8. Nsan

    drop down list

    If IsPostBack Then txttech.Text = DropDownList1.SelectedItem.Text End If Response.Write(txttech.Text) Thx
  9. Nsan

    DROPDOWNLIST

    I cannot capture the value of an item selected from a dropdownlist. The value captured is always the first item in the drop down list.. Code: If IsPostBack Then txttech.Text = DropDownList1.SelectedItem.Text End If Response.Write(txttech.Text) Thx
  10. Nsan

    Stored procedure

    I cannot get the insert statement to run. I get a return value and the insert statement does not get executed. What am I doing wrong. use database go create procedure dbo.ins @tsename varchar(50), @techid uniqueidentifier OUTPUT, @casenum varchar(10), @productid uniqueidentifier OUTPUT...
  11. Nsan

    indexes

    I keep having to rebuild the indexes on a particular table. Can anybody recommend any troubleshooting tips or proactive steps? Thanks in advance
  12. Nsan

    Trigger

    Can someone please tell me what I am doing wrong? I am trying to create a trigger that will convert a negative number to a positive number after an insert. This is how it would be done with Oracle.. Any help would be appreciated... create or replace trigger <trigger name> after insert on...
  13. Nsan

    TRIGGER

    Hi, I need to create a trigger that will replace a value that has been inserted. If a negative number is inserted into a record how to change that value to a positive value. create or replace trigger num_val after insert of n_app on emp begin If n_app = ( a negative number)

Part and Inventory Search

Back
Top