Blog

I have data that is structured like the following: users: id | name | parent_id 1 | Bob | NULL 2 | Jan | 1 3 | Mat | 2 4 | Irene | 2 5 | Ellie | 2 6 | Laura | 5 7 | Uma | 6 user_sales: user_id | sales_period |Read more

I have a stored procedure which calculates the distance between 2 coordinate points: CREATE PROC loc.CalcDistanceByPostalCode ( @From VARCHAR(10), @To VARCHAR(10) ) AS BEGIN DECLARE @data table(From_Place VARCHAR(200), From_Region VARCHAR(200), “To_Place” VARCHAR(200), To_Region VARCHAR(200), Distance decimal(8,2)) DECLARE @postal1 table(ID int IDENTITY(1,1), place_name VARCHAR(200), region_name VARCHAR(200), latitude decimal(12,9), longitude decimal(12,9)) DECLARE @postal2 table(ID int IDENTITY(1,1), place_nameRead more

Hi I made an order for $ 38.00 and was charged $ 54.08 that I cancelled.. my balance says I paid it but the company said they didn’t receive it because the order was cancelled, still I don’t have a refund. If the company didn’t receive it, where did my Bitcoin go? Can I expectRead more

I am struggling with creating a Stored Procedure in SQL Server for getting sales statistics. I have managed to get the information I need out, but the query is a mess and I have probably messed up the table variable by using 3 different ones. Any ideas on how to merge this triple part-query intoRead more

A user uploads a CSV to the server to be inserted into the database and I would like to return a meaningful response to this user. My thoughts : { inserted : x records discarded : y records } I believe also that I should specify what records were discarded because of the inconsistent formatRead more