i would make eiher make a view that features the calcuation, or add a persisted calculated column to my table, and always use that for your display price:

ALTER TABLE YOURTABLE...

there is probably a more elegant way to do it, but i could only think of this:

DECLARE @IM_PRC TABLE(

ITEM_NO INT,

PRC_1 MONEY,

DESIRED_RESULTS MONEY )

INSERT INTO @IM_PRC

SELECT...

simple example on the creation:

after that you change your web.config or whereever you build your connection strings to use this username and the password you apply against it.

Lynn is so right; nothing should be using the 'sa' account. seems like you might be a little new to SQL, and that's why you are using sa for your...

hours to compile? literally? is it eight million lines of code? i'd like to see it, maybe it can be optimized.

well first, changing the database collation does not change the collation of each individual varchar,char,nvarchar and nchar columns in the tables...so you'd still have the issues because those individual...

this might help, and also the default trace can help as well:

select *

from sys.objects

where create_date > GETDATE() -30

or modify_date > GETDATE() -30

or the...

sure; simply go to the database and choose Shrink >>Files like you see above.

change the drop down from Data To Log and run it.

then if you want, you can change...

log files will grow in size automatically. they typically grow for two reasons: either a huge transaction occurred, or more likely, the database option for recovery is set to "FULL"...

to do the equivilent of row-number() in 2000, I've always had to create a temp table with an extra column, insert the data into the table, then run an additional...

jyoti you would not replace part of a string...

here's another script that i use a lot;

i stick it in master, and then in any database i might type "sp_find order" in any database;

and it returns all tables(or views)...

steve whenever i have an overall status that depends on the details, i do not store it in the parent/Orders table. I always try to calculate it based on the...

gotcha; you want to replace any value with isnull...

duplicate post.

no need to cross post to multiple forums it fractures the answers you get ,and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

...