Hi

Can you give us sample of "Format File"

Hi

GO is not a Transact-SQL statement; it is a command recognized by the sqlcmd and osql utilities and SQL Server Management Studio Code editor.

SQL Server utilities interpret GO as a...

User ID of SQL Server account or Windows account?

There is no way to tell unless you have logging inside the stored procedure.

You can see the dependecies of the stored procedure that may not tell you how many tables...

check out the below link

http://www.databasejournal.com/features/mssql/article.php/3521101/Cross-Tab-reports-in-SQL-Server-2005.htm

This uses PIVOT based on your example.

Quesry using joins would be much more sclable...based on the little knowledge that i have but..but again its really depends on the use.

Ex: If i have millions of records then...

Kavin (4/11/2009)

---

Yes I can also think the different ways of approaching a problem. As I am new to SQL I hope this website will teach me a lot and correct...

You Can even check out the below link

http://www.microsoft.com/learning/mcp/mcdba/requirements.mspx

http://www.microsoft.com/learning/mcp/mcts/sql

Its really cool...with 3 different solutions..and all of them are independet :):-)

Simple solution in SQL...

Create Table VJ(

name varchar(10),

reading int,

sq_no int identity(1,1))

insert into VJ

(name , reading)

select 'UNDRI',10

insert into VJ

(name , reading)

select 'UNDRI',11

insert into VJ

(name , reading)

select 'UNDRI',20

insert into VJ

(name , reading)

select 'UNDRI',20

insert...

Hi

In addition to the above solution provided by Kavin, You can even do it with Excel if the volume is not high. Doing this in Excel is pretty straight forward.

1)...

Hi

Check out the below link

Migration:

http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx

SSAS:

http://msdn.microsoft.com/en-us/library/ms175609(SQL.90).aspx

There is no way to convert the SQL Loader control files to BCP format files.

Why dont you try out SSIS..

Florian Reischl (4/10/2009)

---

Hi...

Simple solution :).

But the question is is this...