+1 🙂

prepare yourself and see where you stands...

create table #TableTools (id int identity(1,1), name varchar(15), tools varchar(15))

insert into #TableTools values

('mike', 'walker')

,('mike', 'cane')

,('steve', 'walker')

,('mitchel', 'cane')

,('dave', 'cane')

,('mitchel', 'none')

;WITH CTE AS

(

SELECT NAME, ROW_NUMBER() OVER (PARTITION BY NAME ORDER BY NAME)NOS

FROM...

+1 😛

the information that you have provided is not sufficient for us to understand what you want to achieve?

can you please some more detailed information like what output you want from...

Erland Sommarskog (8/30/2013)

---

SELECT quotename(s.name) + '.' + quotename(o.name), o.type

FROM sys.objects o

JOIN sys.schemas s ON o.object_id = s.object_id

WHERE o.type NOT IN ('S', 'IT')

This will lists all objects...

what result you are getting with this query and what output you want?

please provide some more detailed information

can you please post the query that you have written so that we can see what you have tried and help you

you can use BULK INSERT for loading data from a text file into SQL server table.....

Can you please post the table structure and resultant output that you want

Can you please post the code what you have written with DDL statment of CREATE TABLE, DDL stament of sample data in form of INSERT statment.....

You can folow the link...

magwitch (8/30/2013)

---

Yes, i didn't think that was right. So do you have any idea as to why the @sql will not execute but by cutting, pasting and executing the printed...

I apologize for...

Before FROM keyword....

you are getting error because before statement

FROM sys.databases WHERE name not in ('master','tempdb','model','msdb','ReportServer','ReportServerTempDB')

you haven't use SELECT statement and columns names which you required in your output