I'd also avoid using Money data type if you can

especially if you are using international currencies.

money only supports 2 decimal places, but there are lots of currencies that support 3...

ok - it should return 4, anything that does not contain black OR/AND USA

it has to satisfy both conditions to return the row, so if it has black , but...

• This reply was modified 6 years, 7 months ago by MVDBA (Mike Vessey).
• This reply was modified 6 years, 7 months ago by MVDBA (Mike Vessey).
• This reply was modified 6 years, 7 months ago by MVDBA (Mike Vessey).

I think the real question is why you are using float.

float is an approximation, comparing it to a fixed decimal type (such as money) is always going to have issues.

can...

I used to work for a company using HES and SUS data from different NHS sources in order to provide statistics back the NHS Trusts on performance

the redgate tool is awesome.... you won't be disappointed

disclaimer - I don't work for Redgate 🙂

but the licencing is tricky, if you want to backup 3 servers then it's 3...

although in your example order 789 contains 3 items, do you only want where there are 2 items? both of which are 1 and 2? or if you have 50...

drew is correct (I mean his code is the right way to do it)

• This reply was modified 6 years, 7 months ago by MVDBA (Mike Vessey).

so you are having to put the FK back using WITH NOCHECK?

I can't really see why you have the foreign key in place (unless you are modifying their values to...

you could set the foreign keys to cascade on delete

then all of your child objects would be deleted when you delete the parent row

what's your growth settings on the files?

and are you in full recovery mode? where is the bulk of the data? is it in the log?

I think you will have to manually tune that query

maybe there are a few missing indexes and your data size has got to a point where it can't find a...

are you doing this for a job interview/school exam?

PAGEIOLATCH_SH

Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Shared mode. Long waits may indicate problems...

this is going to be painfull

my advice would be to do it manually

BUT if you query msdb.dbo.sysjobsteps there is a column called "command".. you could try and scrape proc and...

write it up as an article for the site, it's quite an interesting find. I'm sure steve would love it