leohickstein
6/5/2017 - 8:07 PM

excluir toda estrutura alerta de uma loja

excluir toda estrutura alerta de uma loja

delete from [tm].[AlertConfigTypeParameter] where alertconfigid in (select AlertConfigId from tm.alertconfig where name like '%2349%')
delete from [tm].[AlertConfig] where BusinessStrucutureId in (
	2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2753,
	2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,
	2780,2781,2782,2783,2784,2785,2787,2788,2789,2790,2791,2792,2793,2794,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,
	2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,
	2834,2835,2836,2837,2838
)
delete from [ra].[BusinessStructureItem] where BusinessStructureListId in (
	2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2753,
	2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,
	2780,2781,2782,2783,2784,2785,2787,2788,2789,2790,2791,2792,2793,2794,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,
	2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,
	2834,2835,2836,2837,2838
)
delete from [ra].[BusinessStructureList] where BusinessStructureListId in (
	2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2753,
	2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,
	2780,2781,2782,2783,2784,2785,2787,2788,2789,2790,2791,2792,2793,2794,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,
	2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,
	2834,2835,2836,2837,2838
)