Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Microsoft Development

47K

Solutions

32K

Contributors

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Share tech news, updates, or what's on your mind.

Sign up to Post

My task is to archive records from these original tables to the archive tables as shown below; however the original tables have foreign keys define and table 2 has no date to be used in the INSERT where clause predicate -12 week. what would be your approach here, can you give me the directions and script.  thanks,
 



      Original Tables

(1)
CREATE TABLE [dbo].[JSServicesCheckListLog](
         [ServiceLogID],
      FK-[CSC],
      FK-[ServiceTypeID],
         [Comments],
         [ChecklistCompletedDate],
         [ChecklistCompletedBy],
         [CleaningDate],
         [NoShow],

(2)
CREATE TABLE [dbo].[JSServiceChecklistDetailsLog](
      PK-[ServiceDetailsLogId],
      FK-[ServiceLogID],
      FK-[ServiceWorkAreaDetailsID],
      FK-[RatingID],
         [Comments],



      Archive Tables

(1)
CREATE TABLE [Archive].[JSServicesCheckListLog](
      [JSServicesCheckListLogID],
      [ServiceLogID],
      [CSC],
      [ServiceTypeID],
      [Comments],
      [ChecklistCompletedDate],
      [ChecklistCompletedBy],
      [CleaningDate],
      [NoShow],
      [LastUpdateTimestamp],


                         
(2)

CREATE TABLE [Archive].[JSServiceChecklistDetailsLog](
      [JSServiceChecklistDetailsLogID],
      [ServiceDetailsLogId],
      [ServiceLogID],
      [ServiceWorkAreaDetailsID],
      [RatingID],
      [Comments],
      [LastUpdateTimestamp],
0
Free Tool: Subnet Calculator
LVL 11
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

On premises SharePoint 2013 - using 2010 workflows.
I have an alert on a special view of the Workflow History - which will alert me when the description contains "Failed" or "Error" - etc.  So I get an an email when any workflow encounters an error or is canceled.  That works fine.  (This doesn't work for SP 2013 workflows by the way).  I can even issue a log message from the workflow and I'll get a notification using this approach.
However, occasionally (not consistently) some of my workflows generate "Failed on start (retrying)" and just hang.  I must manually cancel the workflow so that it can run again on a modification.  The same workflow will not retrigger and rerun on modification when it's in this state.  If I re-run the workflow, it runs fine.  So it's a mystery why I'm getting failed on start.  I get this every few hundred executions of the workflow and on different records.  
Unfortunately, in this case - no workflow history is created - hence I don't get an alert.
So anyone know how to get a notification when a workflow 'fails on start'?  
You can't set an alert on a view which is filtered by a workflow status column so that approach evidently won't work.
Any ideas?
It's very important I know of failed workflows on this application.

I don't have the option of using SP 2013 workflows - which I understand are less flexible for this kind of alerting anyway.
0
PlEASE FORGIVE.  I am very desperately looking how to ask this eloquently. Not doing to good here.

In SSIS, if you have an incoming dataset that has multiple records for the same PK (like intraday records in a daily processing method), how do I tell the SCD Wizard to expect that?

in my case, even though all of my fields are set to "Historical", they all appear as new, because they are all coming in all at the same time.

    Example data:
    PK, insertion depth, drill depth, bore depth
    1, 1000, 1020, 1022
    1, 1025, 1222, 1233
    1, 1100, 1321, 1333
    2, 1233, 1255, 1022
    2, 2222, 3333, 3333
    3, 1010, 900, 885

Open in new window


I get this in one report.  They all show up as new in base load.  I have a create_dt, and end_dt as my start and stop timestamps.  create_dt has system::startdate for the variable.  How do I get the SCD stage in SSIS to recognize these, and add the timestamps as necessary, whether or not a record in the target table has that PK already?

Thanks.
0
What are the exit criteria in software testing? where I would to stop the testing.
0
Hello,

I have a webservice that I,m trying to apply a custome security, when I try to call the service it display the following error:


http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">a:FailedAuthentication

At least one security token in the message could not be validated.


To add the security I modify the service config file:

[b][b]<services> <service name = "WcfService1.Service1"> <endpoint address="" binding="customBinding" bindingConfiguration="customBindingOasis" contract="WcfService1.IService1"> <headers> <wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"> <wsse:UsernameToken> <wsse:Username>USERNAME</wsse:Username> <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">PASSWORD</wsse:Password> </wsse:UsernameToken> </wsse:Security> </headers> </endpoint> </service> </services> <bindings> <customBinding> <binding name ="customBindingOasis"> <security authenticationMode="UserNameOverTransport" includeTimestamp="false" messageSecurityVersion="WSSecurity11WSTrustFebruary2005WSSecureConversationFebruary2005WSSecurityPolicy11BasicSecurityProfile10"> <secureConversationBootstrap /> </security> <textMessageEncoding maxReadPoolSize="64" maxWritePoolSize="16" messageVersion="Soap12" writeEncoding="utf-8"> <readerQuotas maxDepth="32"
0
I am trying to use VSTS to support my SSMS 2017 projects
I'm using Git Bash which works fine for local repos
However when I try to access the repo on VSTS I keep getting not a gt error messages

What is the URL required to access a project from outside Visual studio?

Note I have setup alternative credentials which work fine
0
(Development is being done in a Window 10 environment)

I need to add a RPT1 port and then redirect and configure it to a hard drive location which contains a GhostScript exe along with an argument list of settings, including the name that I want the .pdf file saved as.  I need to be able to set this to a constant value so that it can be incorporated into a new 64 bit software application that will run primarily on Windows 10 machines yet work with an existing 32 bit application.

I have a working setup on a Window 7 box utilizing Redmon, Ghostscript and the RPT1 redirected port, but hear that the 32 vs 64 bit architecture might present an issue particularly since I keep getting the error message "there is nothing to configure for this port" when during the printer driver installation and configuration attempt in Win10.  

I have attempted to locate and install an 64 bit version of both Redmon Monitor and Ghostscript but they don't seem to exist so I have to come up with a replacement solution ASAP.

Any assistance provided will be greatly appreciated.

TIA,
-Mari
0
VS2010 has a feature to "Restore Window Layout" to relay out all mainframe, menu, toolbars, and dockPanes, without restarting. How do I have my VS2010 wizard-generated MFC MDI app does this programmatically? Thanks.
0
Hello,

I have to implement in a web service header the oasis usernametoken security.

I have seen some documentation that implement it using Microsoft.Web.Services3, but in VB 2005.

What is the Equivalent of Microsoft.Web.Services3 in VB 2015?, are there any example on how to implemented this type of security in VB 2015?
0
Just switched to a new computer and WebMatrix is not available any longer so I am playing around with this product.  How do I get my pages and changes to the server?

Thank you!
0
Microsoft Certification Exam 74-409
LVL 1
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

How do I add developers to the bug assignments list in tfs 2015?

My tester is adding bugs to a project and is complaining that there are no developers in the drop-down list of developers to assign the bug to... I'm not familiar with using TFS as a testing platform; is there a TFS role the developer need to be in?
I guess the base question is: What feeds the bug assignments drop-down list?

Thanks
0
Hello, I am a daytrader in the futures market.  I have four strategies I had a developer create for me using the NinjaTrader version 7 platform.  I plan on marketing these as a bundle product.   I would like to know if any of your products can help me protect the further copying of the product once it is purchased.   The previous products I have purchased in the past from other day trading companies use the Machine ID validation.  Once the product is downloaded, before you can use it, you must have your Machine ID sent to them and it can only be used on that particular computer.   I am looking for that same effect.
0
It is VC++ MFC app in VS 2017 Community under Win 7 Pro SP1.

It is very simple to send and process WM_NOTIFY from a dialog's child MFC control to it parent (or to other window.) In control cpp you fill NMHDR structure for the control, get its parent, and send a WM_NOTIFY message like pParent->SendMessage (WM_NOTIFY,...).

In the parent you set the entry in the message map like ON_NOTIFY(Notification code, ControlID, Message Handler) and the handler is called.

But if yoy set the control ID to ID of the modeless dialog box like IDD_MYDLG and fill NMHDR with dialog's parameters, the handler in the parent is never called. Of course, there is a hack: you can use any of dialog's controls to send the WM_NOTIFY, and all will work.

My question is: Is there any way to send WM_NOTIFY from the modeless MFC CDialogEx using its own  ID?
0
I need to make sure that if a particular value is set in a dropdown that a textbox has some text explaining why the other value is set.  It almost works.  What I did is as follows:
On the data tab,  I selected Submit Options and said to allow Perform custom action using rules
At that point the Forms Submit button was enabled and I added a rule as follows
If SomeDropDown has "SomeValue" and "RelatedTextBox" is not blank allow the submit.

It works in the sense that it won't save the form without the related text if the dropdown has "SomeValue", but it doesn't stick on the page with a message to fix it and just closes as though it is saving the data.  When I do enter "SomeValue" the form saves as expected.

What am I missing and how do I get the "error" condition to appear?
0
Good day  forum


from https://docs.microsoft.com/en-us/windows-hardware/drivers/network/using-bind-or-connect-redirection
"A WFP redirect record is a buffer of opaque data that WFP must set on an outbound proxy connection at
 the FWPM_LAYER_ALE_AUTH_CONNECT_REDIRECT_V4 and FWPM_LAYER_ALE_AUTH_CONNECT_REDIRECT_V6 layers, so that
 the redirected connection and the original connection are logically related."
 
 Am working with  ClassifyFunctions_ProxyCallouts.cpp of WFP driver sample  (https://code.msdn.microsoft.com/windowshardware/Windows-Driver-Kit-WDK-81-cf35e953)
 
 
 What is confusing me is this, being that am working on the (FWPS_LAYER_ALE_CONNECT_REDIRECT_V4) and (FWPS_LAYER_ALE_CONNECT_REDIRECT_V6) (Kernel mode)
 
 How do i set up proxy connection  at this layer.
 
 thank you
0
I have an access 2010 application distributed via the packaging wizard. It works well except that shortcut menus are nos available in forms.
For example, there is no way to copy or paste with shortcut menus.
In the source file they are available.
What should I do to make them available in the distributed package?
Thanks in advance.
0
Everything was going well... playing around with Visual Studio 2017 for the first time...

Had a weird problem (#1, but not really what the question is about where even though I set the Assembly Name and Root Namespace names, ApplicationName was still returning "WindowsApp1" when referenced... so I thought maybe it's building using that temp name when run from VS IDE.  So I compiled it into an app and deployed it.  Same result...

So I try re-opening the project - I can't open forms!  I can a new form, but when I try to open the main form, the only "main" reference I have is main.vb.  And when I open that, I don't have any code either!  I have one other form in the app and I can't open that either (but the code is visible).

I'd really like to continue this project but I need to see the forms!  HELP PLEASE!?!

(Classic Windows Forms app).
0
Hi There!

I have a customer who is a developer. They have 12 staff. 5 Developers 5 support people, 1 director and 1 sales/admin person.

They have an action pack, which covers up to 10 users of Exchange, Windows CALS etc, and that's fine.

What they are trying to do it make sure they are correctly licensed for dev machines, dev environments and testing labs.

It used to be that companies bought MSDN Subscriptions but I think those are now only for individuals and not for use in businesses at large? I had heard about MSDN Platforms but when I checked the pricing the customer just about died.

Anyone know of a more cost effective way for a company this size to correctly license their environment?
0
Hi , When i'm downloading the excel file,i'm getting following attached error.How avoid this error

XML file output


<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error042240_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\abc.com\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\PGARRIST\Report_Isys.xlsx'</summary>


-<additionalInfo>

<info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info>

</additionalInfo>


-<removedParts summary="Following is a list of removed parts:">

<removedPart>Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Illegal xml character. Line 1, column 267478.</removedPart>

</removedParts>

</recoveryLog>
1.png
0
What is SQL Server and how does it work?
LVL 1
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

hi,
I need to write bookmark with parameter in ssrs.
and I don't know the syntax.

Can anyone help me?
0
howshow.png
How to show columns?
0
Hi, new member here and first post. My goal is to create a basic tab control using the Win32 API that contains a canvas for rendering OpenGL. Please see attachment for my source code. I created a tab control with two tabs; the first tab contains a button and the second tab contains the rendering context. The first tab, when active, successfully displays a button. The second tab, when active, does not display the OpenGL canvas. The only way I can get the canvas to appear in the GUI is to exclude the tab control (comment out the CREATE_TAB_PANE macro in my example to do this). I am rendering the OpenGL context within a static control. Thanks in advance for your help.
OpenGlTabWin32.cpp
0
language : c++
(tools : visual studio , acrobat reader)
thanks a lot
0
Guys, i have a question as specified above!

 '' Enable Double-Buffering for everything.
    Protected Overrides ReadOnly Property CreateParams() As CreateParams
        Get
            Dim cp As CreateParams = MyBase.CreateParams

            cp.ExStyle = cp.ExStyle Or &H2000000
            Return cp

        End Get
    End Property

Open in new window

0
Hello Experts,
In continuation to : https://www.experts-exchange.com/questions/29014655/Powershell-help-for-creating-accounts.html
I have a further enhancement request,
I have 2 Columns in SQL
ADGroup & O365Group

These columns contains values, which are separated by comma (,) these are existing groups in AD & O365
I want them to be integrated into the script so that when the new user is created he is added to the respective groups in both the places.

Thanks in advance.
A
0

Microsoft Development

47K

Solutions

32K

Contributors

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.