Thanks. I like to be helpful 😉

I doubt it, since the problem is already solved. It might help someone else though, so thanks anyway.

Jeff Moden (3/10/2010)

---

True enough. But if you can't or won't use a CLR solution, one of the myriad Tally table solutions will do the job very quickly as well...

Views do not contain any data unless indexed, so the question of the order of data in a view only applies to indexed views - which are logically ordered by...

No need for a Tally table here:

Setup

DECLARE @SortTable

TABLE (

id ...

Managing ntext, text, and image data (SQL Server 2000)

I am assuming you are using SQL Server 2000, since these data types are deprecated in 2005 onwards in favour of the...

One option is to use the BULK INSERT statement.

Example:

DECLARE @FilePath NVARCHAR(126),

@sql NVARCHAR(MAX);

-- Construct the file name for today ...

Bob,

I am going to contribute the following code, not as a solution, but as a way to help you describe what you want.

How does the following not meet your need?

DECLARE...

Summary: the way you are currently doing it is probably close to the worst possible. The more details you give, the more specific and useful and answer you will...

Test setup

DECLARE @t

TABLE (

item_no INTEGER NOT NULL,

stock1 INTEGER NOT NULL,

...

To illustrate Jeff's point:

DECLARE @Example

TABLE (

field1 VARCHAR(30) NULL,

field2 VARCHAR(30) NULL,

...

SELECT C.CustomerID,

Loc = ISNULL(CONVERT(VARCHAR(50), CL.Loc), 'Do not care')

FROM @Cust C

LEFT

JOIN @CustLoc CL

...

A couple of points about string-splitting:

1. It is normally best to avoid storing the data this way in the first place.

2. The fastest solutions use a .NET implementation...

Would a computed column work better?

CREATE TABLE tempdb.dbo.ApInsp (CompDttm DATETIME NOT NULL, ExpDttm AS DATEADD(DAY, 180, CompDttm));

INSERT tempdb.dbo.ApInsp (CompDttm) VALUES ('20090314');

SELECT CompDttm, ExpDttm FROM tempdb.dbo.ApInsp;

DROP ...

Chris Morris-439714 (3/10/2010)

---

If the conditions of moisture, temperature, air turbulence and humidity are just right and you can position yourself facing a bright light source with the subject slightly off-centre,...