I do something kind of similar using the SPACE function to reserve a certain amount of space in a string; I used a default of 20 in this example, but...

much easier to do that from an application.

from sql server 2000, it's difficult to do in TSQL because you must use an object with sp_oacreate to get the text of...

thekingironfist (2/11/2008)

---

Hi folks, every time a date is entered into SQL Server 2000 as a 12:00:00 AM time, it becomes automatically truncated to only the date.

Example:

I type:

2/11/2008 12:00:00...

the freespace will just get larger as you cleanup your data, until you shrink the database...when you shrink the database, only then will the actual amount used get smaller. until...

Tim ffitch (2/11/2008)

---

Hi.

We have a Select statement in a stored procedure that uses the IN Operator.

When we use the following style it works:

WHERE IN ('Value1', 'Value2', 'Value3')

However we have a...

there's so many variables, it's hard to give a good answer without reviewing the code;

In general, here's something to look at:

A lot of times, dynamic sql is used in order...

if the database is version 80, the script is not valid for the part i highlighted below...that part is 2005 /90 database only:

CREATE TABLE [dbo].[Primes](

[Prime] [int] NOT NULL,

CONSTRAINT [PK_Prime] PRIMARY...

you need to post more specific details. the code i posted will do what you asked; so you are most likely not converting the final answer.

here's a more detailed example:

declare...

you divided the converted value by 360000.

you want the final result to be a decimal.

try

...

COALESCE would help you in this case...it's really just a CASE WHEN construct:

SELECT COALESCE(HOMEPHONE,CELLPHONE,EMERGENCYPHONE,'911')

FROM SOMETABLE.

it returns the first non-null item...so if homephone is null, it returns the cellphone, but...

you need to cast or convert the value that's in the field as a decimal.

declaration is size,number of decimals:

so SELECT CONVERT(DECIMAL(8,1),YOURCOLUMN FROM YOURTABLE wouold do what you ask.

example:

SELECT CONVERT(DECIMAL(8,1),23.00001)

,CONVERT(DECIMAL(8,1),12.9)

, CONVERT(DECIMAL(8,1),16)

,CONVERT(DECIMAL(8,1),14.567)

Results:

(No...

search for "DBA Toolkit" hereon SSC:

http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/

It's got encryption/decryption, regular expressions and more.

Interesting; I'd like to know how a PRINT statement affects the other procedures;I haven;t tripped over that yet, and do a lot of programming.

Can you explain what goes wrong?

Another idea:...

I've got a collection of functions like that that strip out certain characters, html encode data, etc, all based on Jeff Moden's Tally Table concept.

Try this out for size: it's...

don't forget the SQL DBA Toolkit here on SSC: it contains stored procedures to encrypt/decrypt data, as well as other goodies:

http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/