Viewing 15 posts - 481 through 495 (of 4,820 total)
As has been mentioned, you don't merge SSIS packages. There's no tool that's ever going to be able to accomplish such a task. How could one possibly know what to...
October 11, 2018 at 6:35 am
Please do provide more details. The CREATE TABLE statement for the table involved in getting the duplicate key violation would be a great start, and then the data in the...
October 11, 2018 at 6:23 am
October 9, 2018 at 9:30 am
What the OP has asked for is a list of machines that for ALL of the apps installed on that machine, that all of those appear in the APPLICATIONS table...
October 9, 2018 at 9:16 am
October 9, 2018 at 8:11 am
Hi All,
I have two tables table 1 and table 2.
Table1 :ID Type StartDate EndDate Units
AAA...
October 9, 2018 at 7:43 am
October 9, 2018 at 7:00 am
One could also not mess with the query and instead use a reporting tool where you can have it not repeat values For this data, that would be a...
October 5, 2018 at 7:39 am
laurie-789651 - Friday, October 5, 2018 7:17 AMYou could do this:
SELECT UPPER(LEFT(Month_Name,1)) + LOWER(SUBSTRING(Month_Name,2,8))
FROM abc
This solves only the case for...
October 5, 2018 at 7:36 am
I was just wondering if this made sense actually, I have a EAV table...
October 5, 2018 at 6:43 am
October 4, 2018 at 3:08 pm
If you want to operate on a result set, you can run a query that can return that result:SELECT
CONVERT(bit,
CASE
WHEN OBJECT_ID('dbo.WomenStartListDay1', N'U') IS NOT NULL THEN 1
October 4, 2018 at 1:03 pm
October 4, 2018 at 12:47 pm
Viewing 15 posts - 481 through 495 (of 4,820 total)