Darn it, forogt my end

WHERE

jomast.ftype = 'I'

AND jomast.fitype <> '2'

AND jomast.fstatus = 'RELEASED'

AND jomast.fprodcl LIKE (CASE @Prodcode

WHEN '01' THEN @Prodcode

WHEN '04' THEN @Prodcode1

WHEN '10' THEN @Prodcode2

END)

Sorry had a typo and the edit button won't work

WHERE

jomast.ftype = 'I'

AND jomast.fitype <> '2'

AND jomast.fstatus = 'RELEASED'

AND jomast.fprodcl LIKE (CASE @Prodcode

WHEN '01' THEN @Prodcode

WHEN '04' THEN @Prodcode1

WHEN...

To me this looks like what you are saying you are after

WHERE

jomast.ftype = 'I'

AND jomast.fitype <> '2'

AND jomast.fstatus = 'RELEASED'

AND jomast.fprodcl Like (CASE @Prodcode

WHEN '01' THEN @Prodcode

WHEN '04'...

I have been told Quantum Mechanics are easier for many folks. 😀

I don't know. I am a programmer and never had an issue with understanding the logic of the knows and unknowns.

Best way I ever could think of to describe is...

Just a concept piece I was playing with. Not good for very large data sets in the current form but does a good job as a simple tool

Inputs are

@info-2 -...

Anyother thing could be the stats or usage information need to be refreshed. Try sp_updatestats and DBCC UPDATEUSAGE.

They Search box in the top right corner replaces that page.

chris dietz (9/26/2007)

---

I am in debate with our DBA about storing all codes in one single table or having a code table for each code entity.

A typical system may have...

"Hello....I have 1200 GB drive space RAID 5"

Can you provide a break down of the equipment? How many HD's is there only one RAID controller? How many channels on controller(s)?...

My thought is most of the work actually is happening on SQL Server and not the AS400 machine because of the way the transaction is handled. Openquery will submit to...

How are you writing your query to run on SQL? Have you tried Openquery to see if it behaves more as expected?

Not sure if you can. Couldn't find anything either and it has been 3 years since I last worked with MSDTC.

Ok you create datasets with the data tab of the designer, there you name the dataset, if you look at that tab you will see the drop down for your...

Could be something in one of the jobs specifically doing it, maybe throwing an unmaged error and crashing SQL Agent. Look at all the jobs that run around that time...