I think he is talking about a hierarchical structure. A father / son relationship table of some sort, bill of materials. 1 Bicycle -> 1 frame -> two wheels ->...

Saving a cpu cycle

Select Right(Convert(char(10),getdate(),103),7)

Select Convert(Char(5),GetDate(),101)

Can you post a bit more info like the actual error message,code and the statement executing! Assume both(old,new) SQL 2000?

Look in SQL Server Books Online 2000 and search for 'Deterministic and Nondeterministic Functions' The problem seems to be the determinism of the cast/convert function. If you use the convert/cast...

Try and change '20030101 00:00:00:000' to Cast('1 Jan 2003 00:00:00:000' as SmallDateTime)

Can you post the script indicating which columns are of dates and variants types?

Think I missed the point

Dim fso As New FileSystemObject

Dim folder As folder

Dim file As...

Try the following at

http://search.microsoft.com/default.asp?qu=GetFileName%28strFN%29&boolean=ALL&nq=NEW&so=RECCNT&p=1&ig=01&i=00&i=01&i=02&i=03&i=04&i=05&i=06&i=07&i=08&i=09&i=10&i=11&i=12&i=13&i=14&i=15&i=16&i=17&i=18&i=19&i=20&i=21&i=22&i=23&i=24&i=25&i=26&i=27&i=28&i=29&i=30&i=31&i=32&i=33&i=34&i=35&i=36&i=37&i=38&i=39&i=40&i=41&siteid=us/dev

Alternative is a form of character stuffing but if will depends on your app / enivronment, 2 byte extra per row, instead trigger to add one char,...

BOL 2000:

LEN

Returns the number of characters, rather than the number of bytes, of the given string expression, excluding trailing blanks.

DATALENGTH

Returns the number of bytes used to represent any expression.

Select len('A...

Played with the problem:

Adding a length column for the two PK columns.

Ok assumption no spaces in front

Create Table Testing(A varchar(10) not null,B varchar(10) not null,

C tinyint...

See online help for ANSI_PADDING

Try ROUND function.

BOL 2000:

Returns a numeric expression, rounded to the specified length or precision.

No, normally do it on the client with Crystal or Excel.