Viewing 15 posts - 2,041 through 2,055 (of 8,761 total)
I think the simplest thing is to select from each sheet into a temp table or one temp table for each sheet and do a union query
😎
July 6, 2017 at 4:56 am
Thanks for the info. I'm fairly skilled with SQL but fairly new to SQL Server...
July 6, 2017 at 4:54 am
July 6, 2017 at 4:46 am
Does SQL Server provide a simple easy way to test stored procedures and functions? ...
July 6, 2017 at 3:49 am
My normal approach for this is to shred the XML using XQuery in SQL Server, much more flexible than SSIS
😎
Don't use much 3rd party tools so unfortunately...
July 6, 2017 at 3:03 am
July 6, 2017 at 2:17 am
Is there any way the performance can be improved if a XML input variable is...
July 6, 2017 at 1:38 am
Looks to me like someone is trying to use the old "DTS Password" vulnerability or later variants thereof
😎
Recommend that you remove those attachments immediately!
July 5, 2017 at 4:27 am
Can you post the errors from the log please?
😎
July 5, 2017 at 12:10 am
June 29, 2017 at 9:18 am
June 29, 2017 at 2:47 am
I have a number of DFT in a For Each Loop, I have created variables...
June 28, 2017 at 1:57 am
Note that a stored procedure retains the SET QUOTED_IDENTIFIER settings from when it is created, here is a quick example
😎SET QUOTED_IDENTIFIER OFF;
GO
IF OBJECT_ID(N'dbo.SP_TEST_QI') IS...
June 27, 2017 at 6:31 am
Using excutuion...
June 27, 2017 at 6:05 am
Viewing 15 posts - 2,041 through 2,055 (of 8,761 total)