Search results for query: *

I have the following JSON output from a URL { "motd": { "msg": "If you or your company use this project or like what we doing, please consider backing us so we can continue maintaining and evolving this project.", "url": "https://exchangerate.host/#/donate" }...

Hi, I have the following code which will give me a list of every fortnight between two dates however I want to be able to make the type part of datadd (so WEEK, MONTH, YEAR) etc dynamic. Is this possible? I have tried creating a user defined variable for it but it didn't work. Basically if the...

I am trying to run a date picker on a field within a content page. On the master page in the head section I have the following code: <script src="../assets/js/forms-bootstrap-datetimepicker.js"></script> <asp:ContentPlaceHolder ID="head" runat="server"> </asp:ContentPlaceHolder>] In...

I am trying to receive data from a json feed. I can successfully perform the http request which gives me some json data like below: jsonObject = {{ "data": [ { "latitude": -20.025382, "longitude": 143.314035, "type": "address", "name": "xxxx", "number"...

Hi, I have been tasked with creating a database used to store statistics for various sports. My issue lies in that each of the different sports have different measures or metrics you would store in a database. For eg. Cricket Metrics - Runs, Wickets, Overs, 4's, 6's, Outs, Wides, No Balls...

I have a field in a table with the geography data type. I can write to the field using a lat & long reference which gives me a value of: 0xE6100000010CF4F8BD5D7F063CC059349D9D0C2A6340 When I try to extract the lat out of that field using SELECT GEOLOCATION.LONG, I receive the error: Could not...

Hi, I have a SQL database on shared hosting and the following line in a stored procedure is failing and gives the following error 'Implicit conversion from data type nvarchar to binary is not allowed. Use the CONVERT function to run this query.' It works fine locally on my machine How do i...

Hi, I am trying to find some vba code that will allow me to loop through a specific column of a specific sheet and return a value from another column and write that to a cell in another sheet. So my data to loop may look like A B P100000 10 P134454 111 P100000...

I have the following code which generates fixtures, however I would like to modify the code so I can use the following variables: - Start Date / End Date of Season. So generate fixtures for each saturday or sunday between those two dates - Only schedule matches for specific times - Assign how...

Hi, I am developing an asp.net core website and want to know what is the best way to create different layouts for different role types after they login. I can redirect users to pages no problem after authentication but looking for advice on setup after that. Should I have a .aspx page for...

Can someone point me in the right direction for the best practice approach (security, efficient etc) of consuming data (automatically through scheduled jobs) from a web service daily and storing information into SQL server. a vendor offers a web service where I can pull through my client...

Hi, I am curious to know people's thoughts on whether you would split customer information into separate tables all combine in one. So a table for each of the following: Personal Details - Name, DOB, Gender.... Contact Details - Postal Address, Residential Address, Phone Emergency Contact...

I am using a web page with a linked master page. I have a panel on the content page which I am trying to hide on page load. The following code which is in the code behind file of the content page does not seem to hide the panel. What am I doing wrong? pnlPersonalDetails.Visible = False

Hi, I have a webform (asp.net) which I want clients to complete, which will then populate my SQL tables. However, this form is to be completed before they become a client so the form will be hosted outside of the authenticated area. Its like a client fact find. Get information about the...

I need to query a system versioned table which will group by date but I don't know what to GROUP BY SELECT COUNT(*) 'UNPROCESSED' FROM [PROCESSING].[xxx].[MASTER_xxx_FUTURE_STATE_BUILD] FOR SYSTEM_TIME BETWEEN '2019-01-09 16:59:00.000' AND '2019-01-14 16:59:00.000' WHERE DM_RecordStatus =...

I need help to look up a specified date and time and return column A In a cell I have say 1. 11/01/2019 05:30 AM 2. 12/01/2019 17:05 PM 3. 13/01/2019 15:15 PM In two columns I have A 09/01/2019 17:00 PM 10/01/2019 16:59 PM 10/01/2019 17:00 PM 11/01/2019 16:59 PM 11/01/2019 17:00...

I have the following view: SELECT TOP (100) PERCENT GBL_ADMIN.dbo.ASSET_TYPES.ACCOUNTING_ENTITY, SUM(dbo.ASSET_INFO_DETAILS.VALUE) AS TOTAL_VALUE FROM dbo.OWNERS INNER JOIN dbo.ASSET_OWNERSHIP ON dbo.OWNERS.OWNER_ID = dbo.ASSET_OWNERSHIP.OWNER_ID INNER JOIN dbo.ASSETS ON...

Hi am looking for some advice on best practice for the following scenario. I have a table which contains a list of financial assets - Credit Card, Home Loan, Owned Property When I user selects a financial asset at the front end, I want to record further information regarding the product they...

I am trying to add " to my string so that I can use it in a connection string. Not sure how or where to add it. Dim strConnectionString As String strConnectionString = Session("connectionString") e.g. returns TENANT_1432] but it needs to be "TENANT_1432" to use in the code below...

I created a new login on SSMS. And there is a red cross beside. See picture. Anyone know what this means?