Viewing 15 posts - 1,546 through 1,560 (of 13,849 total)
I need a bit of clarification.
Presumably the inputs to this query would be
a) Mechanic (Mike, in your example), and
b) MessedUpAt (2000-01-03 at 15:00:00, in your example)
Is this correct?
Based on these...
March 2, 2022 at 1:23 pm
Any one got any ideas why the discussion post for today's article, Can We Please Stop Sending Passwords Over the Wire?, has been marked as "spam"?
Someone got...
March 2, 2022 at 10:09 am
Solved with a CTE.
With AcctTrav as (Select * from Accounts where Jdx = 180)
Merge into AcctTrav a
Using TTN5563 t
On t.TaxID = a.TaxID
Nice. Well done on posting...
March 1, 2022 at 9:51 am
I seem to recall a rule in place that if 3 posts for the same user are flagged as spam, the user automatically gets disabled. Is that rule still...
March 1, 2022 at 9:46 am
I've been called many things, but it's a first for Ohil 🙂
February 28, 2022 at 4:24 pm
The people that make spam aren't stupid, the spam constantly evolves as they find new ways to avoid in built spam detection on websites; no doubt this is just...
February 28, 2022 at 3:56 pm
I fragged a load of them earlier. We've been down this road several times before, with many suggestions which sounded like great ideas, though none seem to have ever been...
February 28, 2022 at 3:14 pm
Like this? (With thanks to Jeff Moden for the dates generator.)
DROP TABLE IF EXISTS #t1;
CREATE TABLE #t1
(
PersonId INT NOT NULL
,StartDate...
February 28, 2022 at 3:09 pm
To convert NVARCHAR to decimal, use something like this:
SELECT Cost = CAST(t1.Cost as Decimal(19,6))
Use AVG() to calculate averages.
For more-specific help, please post the sample data in consumable format, along with...
February 28, 2022 at 12:52 pm
SSIS can do it.
Create a dataflow with
Source 1: SQL Server
Source 2: Excel
Destination: Excel
Inside your (source --> destination) dataflow, perform the merge, probably using a MERGE JOIN component.
February 28, 2022 at 11:06 am
Oauth is an authentication protocol and is not relevant for having SSIS talk to SharePoint (SP).
--
Greeting,
Rachel Gomez
SharePoint is not mentioned anywhere else in this thread, so why mention it...
February 28, 2022 at 10:08 am
when i have added 2 rows and max 2 rows is giving '2021-02-19' only one record
('577', '-1', '0', '2021-02-19');
('577', '-1', '1', '2021-02-20');
For me it gives 2 rows.
As you have...
February 28, 2022 at 9:57 am
Based on your sample data, this works, I think. I suspect that more refinement will be required to make it work with actual data. Please post sample data in consumable...
February 26, 2022 at 5:48 pm
Which reporting tool are you using?
If you want a code solution, please provide sample data and desired results in a consumable format.
February 26, 2022 at 10:57 am
Here is required output
('577', '-1','1','2021-02-14');
('563', '-1','1','2021-02-13')
DROP TABLE IF EXISTS #Table_1;
CREATE TABLE #Table_1
(
div_id NCHAR(10) NULL
,customerid NCHAR(10) NULL
,div_status...
February 24, 2022 at 8:25 pm
Viewing 15 posts - 1,546 through 1,560 (of 13,849 total)