Like this

EXECUTE DatabaseBackup
  @Databases = 'BDNAME',
  @Directory = 'G:\BACKUP',
...

• This reply was modified 3 years ago by  dubem1-878067.

Thanks for your answer, in fact those values are not entered by end-user.    They are values of drodown lists,  the end-user select the language at login,   then every dropdown...

• This reply was modified 4 years, 7 months ago by  dubem1-878067.

Great thanks for your answer.
"With No recovery"  that's what I was missing.   So I guess when I restore the diff backup I'll do it "With recovery" ?

Will this really...

Got it

SELECT IDTask, name, [1] as [StatusA],[2] as [StatusB],[4] as [StatusD]

FROM

(

SELECT t.idTask, t.name, ts.idstatus, ts.status

FROM dbo.Task t

JOIN dbo.TaskStatus ts

...

Thank, it works

Can this be done with a PIVOT?

PIVOT is cool!

Is the PIVOT query will perform better than the second quety with multiple SUM ?

Martin

Thanks lowell

I don't think I would have imagine a solution like yours, it's brilliant

But I would like to have your opinion on this query assuming I know the ID_COMMUNITY of...

Thank you, look interresting but my problem is simpler than you think.

A member belongs to only one community

here is an exemple with data.

Let's say I have 3 communities A,...

Ok, here is my two queries. My app call the first one, and if it returns a value greater then 1 my app call the second one.

SELECT COUNT(*)...

Thank you for your answer

My knowledge of T-SQL allow me to write two separates Stored proc, but when it's time to merge them I am lost. I even don't...

Jeff,

with your second solution, the last select return 3 rows, one for each result. I can this select return only a single row, with the most recent...

You are right,sorry, my mistake

Both yout solution give the exact wanted result