DesNorton (1/3/2017)

---

It would appear that the [Id] field in AspNetUsers contains GUIDS.

However, your proc declares @userid as INT, and then tries to assign a GUID to an...

Forget returning the user id or data from any other columns, is it possible to amend the code to just return one value, i.e. either -2, -1 or 1? I...

Hi, happy new year, been away and just coming back to this now.

What I'm not understanding is why the return value is not either -1, -2 or 1. Why is...

Hi Wryan, no I've not tested before but just ran it in SSMS and got the following:

Msg 245, Level 16, State 1, Procedure Validate_User, Line 18

Conversion failed when converting the...

Hi Rob, I don't have a field call NormalizedUserName in the table.

I tried the code from ChrisM@Work on page 1 of this thread and it compiled OK. I'm getting the same error though. Not sure now if it's my vb code...

Thanks again, pleased to see so many willing to help. Maybe cos it's Christmas 🙂

I will reply to the comments soon, just to let you know that I haven't abandoned...

Hi, thanks for the replies.

This code returns the user id but what I want it to return is either 1, -1 or -2. My vb code then uses a CASE...

Yeah that's all fine, the connection is made fine but as I said if I add in those three lines of code the server cannot be found.

David's update query worked fine, thanks 🙂

Thanks, will give it a try.

Hi, thanks Nick's solution sounds the simplest way (to me) to get the data in, and I've now imported into a new table. However being new to SQL I don't...

Thanks tried the import wizard and it said 10 out of 11 rows successfully imported but no new rows appear to have been added. This method anyway seems to only...

I don't understand that. Why do you think it worked for you? If you don't mind, what happens if you import the XML with every field as varchar(50) and then...

Below is the XML. PRICE and RRP convert fine to Decimal(18,2). However LENGTH, DIAMETER, and WIDTH will not but they will convert to float in SQL Server.

<?xml version="1.0"?>

<STOREITEMS>

<CREATED>

<CATEGORY id="127" name="Category...