Jeff Moden (10/7/2008)

---

Heh... some guy had a problem with one of his renegade developers and he asked what he should do about it. Having dealt with a pod wad...

Here's an article from last year that may help: http://www.sqlservercentral.com/scripts/T-SQL+Aids/30754/

OK, let us know how it works out.

This is the only thing that I can think of that might work (see attached).

I am not too familiar with this approach of using the XML bulk loader and annotated...

Like this:

declare @rows int

set @rows = 2001

select TOP (@rows) *

From master.sys.system_columns

This process appears to be broken already, even before your back-end batch processor is added:

What prevents two processes from both reading 1000 from the table and both writing 1001 back...

Shree (10/7/2008)

---

Hi RbarryYoung,

Thanks for your help but i have a...

Glad I could help!

Do you have sysadmin in SQL Server or access to the 'sa' logon?

I think that this should do it nicely:

/*

Simple Dynamic Pivot Example:

*/

--====== Create really cool test data

Select distinct Table_name as [State], Column_name as [City]

Into #Cities

From INFORMATION_SCHEMA.COLUMNS

--====== Determine the maximum...

It is not built-in to SQL Server to work that way. However, some folks have written procedures or programs that can do it. Hopefully someone here can provide...

Well it depends on what you are trying to pass it to. Please provide code examples of what you want to do and we will try to show you...

dr_csharp (10/7/2008)

---

thanks Jason you are right,but why we do this ?

i...

Jason (10/7/2008)

---

I need to import data from an Excel file into a SQL table. Can you provide me either links on good resources for this information or a way to...

Pass a parameter from a temp table to what? It is not at all clear what you mean. Could you provide some examples of what you would like...