TY Tyson!!!!!!

I will try this code. I appreciate you taking time to write code and share it with me.

Sean please stop replying to my threads

You are not helpful at...

adrian.facio (4/25/2012)

---

Hi,

I prepared the following steps of my solution, when i struggle to understand a query i break it down to the very fundation, then i add one thing at...

Lynn Pettis (4/24/2012)

---

wutang (4/24/2012)

---

adrian.facio (4/24/2012)

---

Hi, what do you think about this one?

-- A tally table is needed.

CREATE TABLE Numbers (Number INT)

INSERT INTO numbers

SELECT TOP 1000 row_number() OVER (

ORDER BY...

adrian.facio (4/24/2012)

---

Hi, what do you think about this one?

-- A tally table is needed.

CREATE TABLE Numbers (Number INT)

INSERT INTO numbers

SELECT TOP 1000 row_number() OVER (

ORDER BY column_id

)

FROM sys.columns;

-- Number...

I am showing you current output and desired output.

What SQL code should I use to copy a record?

Ty for your reply.

I think you are confused with what I am asking.

Basically all i want to do is copy a record(s).

How do I copy a row and change the...

hey,

the article is fine but my scripting is beginner

I'm getting syntax errors

can i perform a select into with openrowset?

the name of the file is abc.xls in C:

what i want to...

Thanks for the quick reply noel

wanna double check that link?

wouldn't every row number be distinct ?  

 

 

 

 

i agree why don't you format it in the front end

are you saying thanks to me?

 

SET @QueryStr = 'Select * FROM table1 WHERE col1 IS NULL or  col1  = ' + ' '

i dont mean to sound rude or anything but are you a girl brandie?

Jeff is SQL MVP

Thanks Noel

 

my hero