DECLARE @Detail_SQN int, @Grouping1 varchar(100), @Grouping2 varchar(100), @Description varchar(255), @Text varchar(255), @Entity varchar(37), @Entity_SQN int SET @Detail_SQN = 0 set @Grouping1 = ? set @Grouping2 = ? set @Description = ? set @Text = 'No Category' set @Entity = ? set @Entity_SQN = ? --This query gives me the correct result to add into the DIM_Category table Select distinct @Detail_SQN,Grouping1,Grouping2,Description,@Text,Entity,Entity_SQN FROM DIM_Category where Entity_SQN in (4727,4739,4747,4750,4751,4752,4754,4755,4759,4764,4765,4766,4771,4779,4784,4788,4790,4792,4793,4800, 4801,4802,4803,4804,4806,4807,4811,4815,4816,4817,4823,4832,4833,4835,4856,4857,4875,4888,4893,4913, 4947,4952,5028,5032,5033,5035,5036,5037,5039,5040,5041,5046,5049,5055,5059,5060,5061,5062,5258,5259,5261, 5262,5264,5265,5274,5279,5366,5367,5369,5663,5666,5667,5670,5673,5674,5675,5676,5681,5683,5685,5687,5688,5690, 5691,5692,5693,5694,5695,5696,5697,5699,5705,5734,5743,5744,5772,5848,5871,5883,5894,5914,5956,5957,5966,5983,6027, 6070,6096,6125,6148)
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.