If I understand the question, why don't you just maintain this data in a table? Even if it's only one or two rows, you can join against it when you...

1 & 2, definately.

I'm not sure I understand what #3 is.

Be very, very nice about it, but get it down in writing that you're suggesting this might be a poor decision. Then, as long as you're getting paid... train away....

What does the procedure GETSTOCKLEDGER do? It sounds like you may have incorrect syntax in there, but it could be something wrong on the server itself.

No. That's a bad plan. If you're maintaining a 2000 database, you should be testing against a 2000 database. There were changes, not necessarily big ones, but they're there, to...

I had to clean up your code just a bit, but it works just fine:

--created the tables so I could play

IF NOT EXISTS ( SELECT *

...

Oops. Modulo 3.

:blush:

twity61 (4/30/2008)

---

what do I examine the clustered index?

yes. the users selecting the data that is being updated.

the update take about 15min.

snapshot isolation is good idea. I think it's...

I wasn't thinking about it earlier, but you could just write the whole thing in SSIS. That will multi-thread very well.

Have you run a trace to capture the calls coming in to the server? Even if you identify a CPU problem, you need to figure out what's causing the problem.

a2zwd (4/30/2008)

---

Hi,

I am developing an application to a garment factory. I have a doubt in designing a table.

Basic tables:

Jobs, JobColors, Material, Units, Currencies ...

These tables are designed with normalization rules.

I...

Yep. TSQL is a scripting language. As such it's sequential. To launch a seperate "thread" you have to make a completely different connection and launch a script from there.

You can look it up in more detail in the Books Online (the SQL Server documentation), but Text is a BLOB or Binary Large Object data type. It stores data,...

You can switch over to the decimal data type and you shouldn't lose any of your data. You'll have to write a script that migrates it over course, but no...

You can get that specific count for your manager one of two ways. Safely:

SELECT COUNT(*)

FROM MyTable

WHERE MyColumn = 'OldValue'

Or not so safe:

BEGIN TRAN

UPDATE MyTable

SET MyColumn = 'NewValue'

WHERE MyColumn = 'OldValue'

ROLLBACK...