try this - its just a guess

IF (DATE_PART('DOW',CURRENT_DATE) IN ('3','6'))

begin

(put brackets around your evaluation)

are you using visual studio or sql management studio ?

I can't replicate the issue

have you tried

declare @result

select @result=substring(@pippo,256,10)

can you post the code  in text format  please - its easier than all of us manually typing it in

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 ago by MVDBA (Mike Vessey).
• This reply was modified 6 years ago by MVDBA (Mike Vessey).
• This reply was modified 6 years 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 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...