Viewing 15 posts - 271 through 285 (of 297 total)
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
There are a few contradictions in your question, I think. Do you want the query execution time or the tables ticket time to determine the ticketdate to select?
Either way, try...
June 22, 2016 at 11:23 am
pharmkittie (6/10/2016)
June 22, 2016 at 10:06 am
Eric M Russell (4/4/2016)
Actually there is a fork of MySQL 5.5 that supports ANSI-2011, PL/SQL, and T-SQL 2012. In addition to that, it has distributed scale out capability.
You do know...
April 5, 2016 at 1:38 pm
Personally I'm waiting for DB2 on MySQL.
That doesn't make as much sense, I think. The DB2 database is already available on nearly every platform.
April 1, 2016 at 8:37 am
Viewing 15 posts - 271 through 285 (of 297 total)