hey right!!!!!

but my question is what the stored procedure does and if possible explain @COMMAND string with ?. some thing new to me

the code is calling system procedure called sp_MSforeachdb which will return some records and the records...

Torsten Schüßler (5/5/2008)

---

Hi sram24_mca,

something like this:

c:\csvtest.csv:

1,James,Smith,19750101

2,Meggie,Smith,19790122

3,Robert,Smith,20071101

4,Alex,Smith,20040202

Database Table:

CREATE TABLE CSVTest

(ID INT,

FirstName...

hi steve

i am using sql 2000. how can i answer this question?

Better seperate questions for sql 2000 and 2005, since i could not answer well.

hope you do the needfull

once you have records in EMPLOYEE table thru INSERT then there is only way is update.DONT CONFUSE YOURSELF.CTE IS FOR SOME OTHER PURPOSE.which will not a soulution for your problem

sharma (5/8/2008)

---

Hi Tables are restructrued by adding id in all the tables.

ID in Address table is pk & ID in qualification table is FK

Initailly Employee table is empty.

Address tbl contains...

sharma (5/6/2008)

---

Hi i am having three tables (EMPLOYEE,ADDRESS,QUALIFICATION).

The below is table structure

EMPLOYEE

id

name

pg

street

city

state

pg

ADDRESSstreet

city

state

QUALIFICATIONug

pg

The above is table structures.

I need to select values from address & qualification tables and insert the same into...

No it is not column seperator, it is charactre in the string. see my previous post . which making a string seperated by commas

hey.. i confused.. i was saying to Grant not jeff and not ryan

mahesh,

even it has query plan. it should scan the base tables.

sorry not jeff

Ryan

your understanding is right....

sharma (5/6/2008)

---

Yes GSquared.

For initial data dumping i need to do that way only.

I am having one table. But i need to fetch data from two tables and insert into one...

Grant Fritchey (5/6/2008)

---

It's not an alias you're looking for but some formatting. Try changing to this:

CAST(SizeInGigs=floor( backup_size/1024000000) AS VARCHAR) + ' GB'

An alias is a way of masking or...

hi

i am using sql 2000, then the answer is wrong

mahesh

what about ','. the technique is to remove tryling commas