Try this:

SET NOCOUNT ON

DECLARE @PhoneNumbers TABLE

(

ID INT IDENTITY(1,1),

TEL1 BIGINT,

TEL2 BIGINT,

TEL3 BIGINT

)

INSERT @PhoneNumbers (Tel1, Tel2, Tel3)

...

Jeff Moden (9/18/2010)

---

ColdCoffee (9/18/2010)

---

Jeff Moden (9/18/2010)

---

ColdCoffee (9/18/2010)

---

Jeff, PFA the results my DESKTOP..

Mine runs on

OS : Windows 7 Ultimate,

SQL ...

How about this:

--: Declare local variables

DECLARE @command VARCHAR(50)

DECLARE @Folder VARCHAR(50)

SET @Folder = 'P:\Documentary'

SET @command = 'dir /b /s "'+@Folder+'"' -- Place you

-- Declare a temp table to hold...

Jeff Moden (9/18/2010)

---

ColdCoffee (9/18/2010)

---

Jeff, PFA the results my DESKTOP..

Mine runs on

OS : Windows 7 Ultimate,

SQL ...

Jeff, PFA the results my DESKTOP..

Mine runs on

OS : Windows 7 Ultimate,

SQL ...

Varinder Sandhu (9/18/2010)

---

found the solutions...

actually if the tables lie in different dbs

then create temp table in db X that contain the data of tableB from db Y

this way...

SPACE can do it for you

SELECT SPACE( LEN( Col1)) + Col1 from <your table>

And as Wayne suggested, u can use REPLICATE as well.. like:

SELECT REPLICATE(' ' , LEN(col1)) + Col1...

Just a suggestion : Drop the temp table in the SP before it is getting created. like :

IF OBJECT_ID('tempdb..#temp') is not null

drop table #temp

create table #temp (a int, b varchar,...

Fantastic... thanks for the appreciation EasyBoy.. 😀

Awesome feedback , Mike.. I concur completely on whatever u said about SQLServerCentral.. :smooooth:

EasyBoy (9/16/2010)

---

When i execute the following query i got the message.

I couldnt find out what exactly the problem is.

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near ')'.

DBA

Msg 208,...

Try this :

DECLARE @I INT

DECLARE @C INT

DECLARE @Name VARCHAR(800)

DECLARE @command varchar(max)

SET @I = 1

SELECT @C = COUNT(*) FROM SYS.SYSDATABASES

SET @Name = ''

SET @command = ''

DECLARE @Table_Name VARCHAR(800)

SET @Table_Name = 'DB_ROLE_'...

Saravanan, we have told a gazillion times to post the tables structures, sample data et all (i myself have told u and pointed u to the article by Jeff Moden,...

First of all, thanks to u too for posting the question fantastically..Secondly, recursive queries, WHILE Loops will all produce the result, but the FOR XML thing is fast and furious.....

Dear Muratingol, please provide some sample data and the table structures so that we will give you what exactly you want!