I just tried this:

CREATE TABLE [dbo].[tblA](

[pk] [int] IDENTITY(1,1) PRIMARY KEY,

[col1] [varbinary](8) NULL,

[col2] AS (CONVERT([varchar](18),[col1],0)),

[col3] AS ([sys].[fn_varbintohexstr]([col1])),

[col4] AS (CONVERT([varchar](max),[sys].[fn_varbintohexstr]([col1]),0)),

[col5] AS (CONVERT([varchar](18),[sys].[fn_varbintohexstr]([col1]),0)),

[col6] AS (upper(CONVERT([varchar](18),[sys].[fn_varbintohexstr]([col1]),0))))

Then:

insert into dbo.tbla (col1)

select...

select (column list)

from dbo.Table

where len(column) > 8

The problem is the colum in the Order By. Needs the table alias on it.

The difference is that 80 (SQL 2000) can't order by a column alias, while 90...

(Emphasis added.)

Totally agree with you, so long as that statement is included. But that...

Jeff Moden (4/22/2008)

---

Heh... then why have you posted so much on this thread about speed? 😉 The real answer...

Leo Nosovsky (4/22/2008)

---

Ah, persisted computed column -- I've never used it! That may be just what I need. Do you know if there is a performance impact while running queries...

Grant Fritchey (4/23/2008)

---

Until you're down to squeezing the last 10-20ms out of a query, I don't think it matters. COALESCE has a lot more flexibility than ISNULL, so, I'd say,...

I just ran a simple test:

create table #NullTest (

ID int identity primary key,

Date datetime)

insert into #nulltest (date)

select

case

when number%10 > 0 then dateadd(day, number, '1/1/2000')

else null

end

from common.dbo.bignumbers

set statistics io...

First, I recommending looking into getting SQL Server Integrations Services (SSIS) to import the files into a flat table. Same columns as the files you're importing.

If you're dealing with...

If you actually mean DTS, I'm not sure what to do. If you mean SSIS (which I'm assuming because of the forum you posted this in), then take a...

I haven't tried this, but would it be possible to drop the identity column from the temp table before you do the insert into the primary table?

Theoretically, that might work....

When you query the data, add "Order By display_id desc". The "desc" at the end makes it go from highest to lowest.

That should do what you need.

It's a display option. Access "double" = SQL "float". Same storage, same format.

If you're viewing the number on a form, set the display options for the field to...

Instead of an after/instead of insert trigger, would it be possible to add a default value to the column?

For example:

alter table MyTable

add constraint DF_Date default (getdate()) for DateColumn

That would make...

Piper Skip (4/22/2008)

---

Neither suggestion works. The interesting (frustrating) thing about this is the fact that it fails only when included within a stored procedure. Running the two statements...