Good morning,
Right now it is running, since I restarted the server, the problem is that it doesn't happen every day.
The job is an ssis package that calls store...

I need to add that we don't have a huge server, the virtual server is 32, and we have allocated to the server 16 of those (we also run ssis...

There is no error in the log, there is not prolonger blocking.
It happen in two different jobs.
One jobs is an ssis package the basically runs merge statements.
the...

Thanks so much to both of you. I took apart Joe's query to understand it and I made it work as John suggested.
The only thing is that the row...

Thanks, but that is not what I am looking for.
I made a mistake on my sample also, I am trying to get a count into a new table.

Thanks, I solved it already 🙂
and belated happy birthday!!!! 🙂

yes i read it and i tried, but it didnt work, it game me wrong date on 5% of the dates, and no need to be nasty, we are all...

oki, I have almost figured it our, I have a table with a columns date, so here is what I did (I am not a 100% about the weeks in...

Basically we are talking about a fiscal year.
The year starts Jan 1st
the months start on each month. as the quarters do too and last but not least the...

I know where my problem is ::), but whatever I coded didn't give me the right answer. that is why I asked for help. 🙂

thanks, but that is not what i was looking for

thanks, I did added it in the code after I posted.

that is what at did, but i still don't know how to do that in a trigger :crying:

Hi,

Thanks for your reply, but I just wrote an example.

the table i need to work on, it is not define by me, neither i can define it or change it,...

I guess it is hard to understand. but i have written a sample of code.

this sample is good if the customer choose population_1 that means

ind_1 > 0

ind_2 > 0

or...