I have used the OPENROWSET command to export data from a 2000 DB to a CSV file using this code:

--OPENROWSET to Text file From DB table to text file.

--Text...

My guess it the...

The table can be modified to allow for cascading deletes which is discussed in BOL at:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/54ca1d10-5106-4340-bde4-480b83e7e813.htm

Read carefully the reference in its entirety. As noted if 3 or more tables...

Duplicate posting at:

http://www.sqlservercentral.com/Forums/Topic825684-1291-1.aspx

Please answer in above forum

TheSQLGuru

Thank you for the rcommendation.

Trying using Books On Line (BOL) the help file for SQL server. You will find a listing of 20 such items. Select the one you want and read.

ashok

CREATE TABLE #Books(BookName VARCHAR(20), Price MONEY, Author VARCHAR(50))

INSERT INTO #Books

SELECT 'C++', 150, 'kanithkar' UNION ALL

SELECT 'C++', 150, 'kanithkar' UNION ALL

SELECT 'C#', 150, 'kanithkar' UNION ALL

SELECT 'Net', 250, 'smith' UNION ALL

SELECT...

How are you doing the import from the Excel spread sheet.? Using SSIS or a T-SQL statement using OPENROWSET, Bulk copy?

Garadin

Perhaps, no, I was off base, having only experimented with 6 and 8 characters in the random string. For grins and giggles and to help some other OP...

Garadin

And even though these random string generators may be very good for what they do, none of them get you out of having to do a loop to create...

Heh... I always have to laugh at articles like that... they talk about performance and "better" ways to do things but they all end...

MissyDaisy modify your T-SQL as:

--Your T-SQL

select distinct top 10 customerid, NTILE(10) OVER(ORDER BY CustomerID ) from @SampleInput

--Modifed T-sQL

select distinct top 10 customerid, NTILE(10) OVER(PARTITION BY customerID ORDER BY CustomerId...

Sharul Nizam

Is your question about how to use that fantastic function developed by

Lynn Pettis ? Assuming it is here is a start .

If it is to insure the string...

Now I do not really know why you are doing these calculations, but you could add one more item to the code to give you an overall view of the...

Is this what you mean?

CREATE TABLE #T(tmessage VARCHAR(200))

INSERT INTO #T

SELECT 'Short' UNION ALL

SELECT 'Longer' UNION ALL

SELECT 'Even a longer message' UNION ALL

SELECT 'A realy realy realy extra long message'

select SUM(200...