This really depends on your requirements (you haven't really given us enough to work on)

I would go for a single instance, especially if you are using linked servers in any...

I've had an argument with my ex partner in the past, she claimed that women were discriminated against in the software world.

the truth is that I don't care if you...

it looks like this could be a simple merge statement, maybe that's what they were looking for, but I agree with jeff..

last time I looked the GP data came embedded in the Clinical care group data (CCG) - but it's been 2 years since I touched that stuff - it was...

this might help

https://www.apexsql.com/sql-tools-plan.aspx

if you get Redgate sql prompt , there is an option to expand *

I believe if you look at apexsql website you might also find a free tool that also...

As far as I can see DBCC Dropcleanbuffers won't allow you to specify a database

but dbcc freeproccache can drop individual plans - if you can identify the plan handles by...

I'm sure someone will have a better solution, but I can only see this being done with a cursor and dynamic sql

you'll need a table mapping <fineamount> to whatever the...

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

post the command you are executing , we probably can't help you without the original syntax

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