Viewing 15 posts - 256 through 270 (of 285 total)
An additional note:
If for some reason it is necessary to keep the two source datasets in separate sections within the combined dataset, one can add an Id for each one...
February 1, 2018 at 11:40 am
drew.allen - Tuesday, January 30, 2018 9:12 AMAnd there is only one sort on the entire UNION.
Yes, exactly, and that is probably where...
February 1, 2018 at 11:22 am
DesNorton - Wednesday, January 31, 2018 10:31 PMTry changing your JOIN to a LEFT JOIN
LEFT JOIN alone will not cut it. You'll...
February 1, 2018 at 10:32 am
@Stix83
It is not really clear (to me at least) what you want to do. Some sample data and desired output would go a long way towards allowing...
December 12, 2017 at 8:42 am
You could change the sp to write to a temp table and then based on a parameter value copy the temp table data to either of your permanent table versions:
December 7, 2017 at 11:15 am
Dts.Variables["User::FileExistsFlag"].Value = 1;
Even if I set this to 1. My task isn't doing the...
July 13, 2017 at 11:57 am
Since you mention you need to capture changes made by a stored procedure, I will also mention that you can use the OUTPUT clause to copy before and after values...
March 9, 2017 at 1:34 pm
February 6, 2017 at 12:45 pm
I have not tried to link to an Oracle server, but this is most likely a driver issue.
Maybe some of the Oracle table columns are of types that aren't...
December 30, 2016 at 2:54 am
mcfarlandparkway (12/27/2016)
This didn't worked for me - Select * From table where SubString(ID,1,3) <> 'ING"It still showing all the records that starting with ING
This indicates that your data string is...
December 30, 2016 at 2:30 am
Jeff Moden (12/14/2016)
wanttolearn1 (12/13/2016)
to be more clear this is an example of what i want to produce (the number in the square is the subnet selected)
So take what I did...
December 14, 2016 at 10:47 am
Hi,
How does this version perform, I wonder?
--TRUNCATE TABLE Metrics
--GO
DECLARE @CurrentWeek INT = DATEPART(wk, GETDATE());
WITH
Table1Metrics AS (
SELECT
t.Application,
AVG(t.Performance) AS App_Performance,
AVG(t.Availability) AS App_Availability,
DATEPART(wk, t.Timestamp) AS INPUT_WEEK
FROM
Table1 t
GROUP BY
t.Application,
DATEPART(wk, t.Timestamp)
),
Table2Metrics AS (
SELECT
t.Application,...
December 14, 2016 at 10:17 am
SQLTestUser (8/15/2016)
From the two time periods on Logdatetime itself
Sorry, but this doesn't make much sense.
I will have to take a wild guess.
For your purposes it would have been best if...
August 16, 2016 at 9:42 am
drew.allen (6/22/2016)
select *
from tickets
where ticketdate = CAST(DATEADD(HOUR, -6, GETDATE()) AS DATE)
If you have a range that you are trying to fit into another range of the...
June 22, 2016 at 12:40 pm
TheSQLGuru (6/17/2016)
I would do it with an AND NOT EXISTS (SELECT ...) clause myself.
As would I. 🙂
select distinct item_id
from jec_item_sup jis
where supplier=77
and not exists (select * from jec_item_sup where supplier=jis.supplier...
June 22, 2016 at 11:52 am
Viewing 15 posts - 256 through 270 (of 285 total)