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...

This worked though SELECT geolocation.Lat as Lat, geolocation.Long as Lon from INVESTOR.PROPERTIES I read something about case sensitivity regarding spatial data

Yeah tried that. still doesn't work.

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...

This is still throwing an error. Here is my addnewuser code ALTER PROCEDURE [AUTH].[spADDNEWUSER] @pUSER_ID int ,@pUSERNAME NVARCHAR(50) ,@pPASSWORD VARBINARY(MAX) ,@COUNTRY_CODE NCHAR(2) ,@RESPONSEMESSAGE NVARCHAR(250) OUTPUT AS BEGIN SET NOCOUNT ON DECLARE @SALT...

This is still giving me the same error when I execute the stored procedure. ALTER PROCEDURE [AUTH].[spADDNEWUSER] @pUSER_ID int ,@pUSERNAME NVARCHAR(50) ,@pPASSWORD VARBINARY(MAX) ,@COUNTRY_CODE NCHAR(2) ,@RESPONSEMESSAGE NVARCHAR(250) OUTPUT AS BEGIN SET NOCOUNT ON DECLARE...

I will try to understand your advice and implement. Why would it work locally? Would this be a security setting on the shared server as to why it would not work. The original code works fine and authenticates the user successfully locally. Thanks again

This is my procedure for adding a new user ALTER PROCEDURE [AUTHENTICATION].[spADDNEWUSER] @pTENANT_ID int ,@pUSERNAME NVARCHAR(50) ,@pFIRSTNAME NVARCHAR(50) ,@pSURNAME NVARCHAR(50) ,@pEMAIL_ADDRESS NVARCHAR(50) ,@pCOUNTRY NVARCHAR(50) ,@pPASSWORD NVARCHAR(50) ,@pUSERTYPE int...

Nvarchar Should it be something else?

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...

Sorry probably should have posted my code. It is because I only wanted to find the value P100000. However, now I need to loop through a column with different numbers, so how can I modify the code below. Basically, I have an organisation structure in rows where there is a PositionID and...

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...

Thanks for your reply. I was looking for suggestions on best ways of getting the data into SQL Server. Should I consume the web service using asp.net (app language) or is there a way to do this from a stored procedure and an scheduled job

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...