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 derfloh 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: sinCity99
  • Content: Threads
  • Order by date
  1. sinCity99

    How to insert data from a table into the same table?

    Hi, I need to copy data from one table into the same table but with some different values as well. Also i'm having trouble since row_timestamp cannot be null. Example: Table has columns A, A1, A2, A3, A4, A5 I need columns A1, A2, A3 to be copied and i also want to insert new values into A4...
  2. sinCity99

    Loading data from Excel

    I have 2 columns from an excel sheet that is in the order that i want to reorder my table into. Example: my current table A: pat 2 ryan 33 bob 45 chris 6 My excel sheet has the correct sequence: pat 33 ryan 6 bob 2 chris 45 How can i update my table A so that it matches my excel sheet...
  3. sinCity99

    Converting date format

    Hi, I need to convert a date 20091011 to 10/11/2009. This is how i'm converting it: convert(varchar,cast(ap.appt_date as dateTime),101) as Date but my return is 10/11/20 it keeps leaving out the last two numbers of the year.
  4. sinCity99

    Duplicate in another table

    Hi, I need a way to eliminate data from table A if it exists in table B. I need to combine these two tables but show their similar data only once..how can i do that? Example: Table B data: john 10/11/2008 book john 5/10/2008 novel table A fields: john 10/11/2008 book Results...
  5. sinCity99

    Select only numeric data from a varchar field type

    Hi, How can I only select numeric data from a varchar field that consists of both numeric and string data? Example: Column Name contains the following data: 23546 16565 43546 Jeff John Jack How can I only display the following, is there a function in sql server that does that? 23546 16565 43546
  6. sinCity99

    Stored Procedure to insert a table into another table Problem

    Hi, I have table1 and table2 and i want to fill information from table1 into table2 using a stored procedure. Here's what i have: create sp_table2 (@personId varchar(36), @value varchar(40) OUTPUT @value1 varchar(40) OUTPUT) as begin insert into table2 (date, first_name, last_name...
  7. sinCity99

    Stored Procedure to insert into another table

    Hi, I have table1 and table2 and i want to fill information from table1 into table2 using a stored procedure. Here's what i have: create sp_table2 (@personId varchar(36), @value varchar(40) OUTPUT @value1 varchar(40) OUTPUT) as begin insert into table2 (date, first_name, last_name...

Part and Inventory Search

Back
Top