Search results for query: *

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...

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...

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.

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...

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

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...

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...