Viewing 15 posts - 5,731 through 5,745 (of 13,879 total)
@Patrick123 - Tuesday, April 11, 2017 12:43 PMHi,
Can we delete data from parent table (1 year data) and child tables(6 months data)??
This not...
April 11, 2017 at 12:48 pm
Hi all - thanks in advance for any suggestions, they are appreciated.
I have a need to...
April 11, 2017 at 11:59 am
Does anybody know a way to install the conflict viewer tool without installing SQL Server...
April 11, 2017 at 6:18 am
It's not totally clear to me how you want the data to be broken down.
Can you post a couple of rows of source data (including only a subset...
April 11, 2017 at 6:16 am
April 10, 2017 at 4:30 pm
April 10, 2017 at 2:28 pm
April 10, 2017 at 1:32 pm
April 10, 2017 at 12:55 pm
Your file path appears to start with a single quote and end with a double quote: was that deliberate?
April 10, 2017 at 12:44 pm
Here is another way:
CREATE FUNCTION dbo.GetSaturday (@Date DATETIME)
RETURNS DATETIME
AS
BEGIN
RETURN
(
SELECT FirstSat = dates.dt
FROM
(
VALUES
April 10, 2017 at 10:46 am
Rather interesting idea, and frankly I think they can also...
April 10, 2017 at 7:23 am
Here is some SQL which does this, on the assumption that the value with the highest percentage split is the one to be 'corrected'.
DECLARE @SplitPc TABLE (SplitPercentage DECIMAL(18,...
April 10, 2017 at 6:10 am
In this instance, which results would you deem as 'right'? I'm assuming that you want want of those results to round down by 0.01, but which one and what is...
April 9, 2017 at 6:21 pm
I advise you to check the All Executions report (assuming your package is deployed to SSISDB) to work out the running times for the individual components of the package, in...
April 7, 2017 at 7:11 am
Viewing 15 posts - 5,731 through 5,745 (of 13,879 total)