It appears that you are attempting to create a facility that already exists in SQL Server 2008 .... might I suggest that you use Books On Line (SQL help file)...

You have posted your question in a SQL 2000 forum ... CROSS APPLY WAS introduced in SQL Server 2005 ...

For SQL 2000 CROSS JOINS exist and they exist in...

As one who has been beaten from pillar to post during the discussion of QOD's that I have submitted and which where published ... I am sorry to say that...

I believe this article by Jeff Moden will assist you:

http://www.sqlservercentral.com/articles/T-SQL/63003/

jyoti_bhatt

Is the above actually what is in your CSV file or is it:

Name Address Phone Age something something

aaa,bbb,20,,xxx,, -- where...

May I suggest reading the following

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

It has all that you want to know about interfacing with EXCEL and more, great sample code.

kaspencer

I suggest that before allowing a question to be used, the submitter must ensure that all assumptions and pre-conditions for the question be stated clearly. These assumptions would include...

ndixit

In order to receive help we need you to help us help you.

Please read the first article in my signature block and post the information accordingly. That is...

dallas13

Sorry, but I am rather dense, and do not understand your amplified explanation. Some items is question:

1. Does user pass in a single parameter value?

2. If...

Is this what you are looking for?

select @visa = @visa + @year --note removed '

Print @visa

SET @visa1985 = 'select '''+@visa+''''

PRINT @Visa1985

Returns:

561985

select '561985'

yacov-1006505

Thank you for your feed back ....

QML

Can you clarify your definition of size. Want to know the defined size, or the actual amount of data stored in a particular column or columns?

That said you...

yacov-1006505

Please check the database properties, using SSMS, and see if the Auto Close open is set to "YES" or "No".

Do you measure performance in SSMS when you click the Execute...

Read this article, pay attention to the discussion of the undocumented stored procedure

SP_MSForEachTable

sp_msforeachtable is very similar to sp_msforeachdb, except executing the command against every table in the database....

Not being an Excel expert, have you looked at background checking and its rules.

In Excel

Click your way down the Menu Bar:

Menu Bar

Tools

...