Click here to Skip to main content
15,916,091 members

Comments by shivprasads (Top 6 by date)

shivprasads 27-Jun-13 3:29am View    
Alright it was indeed helpful and i revoted it to 4 but actually i would like to say that the solution posted by Radhadeep12 was more apt and so i accepted it as answer.
shivprasads 27-Jun-13 1:53am View    
thanks for the reply,
this was indeed helpful but was a bit tricky to understand and more complex.
anyways thanks again for the efforts
shivprasads 27-Jun-13 1:51am View    
Thanks a lot Radhadeep12 .
That was completely helpful.


Though I kept the initial approach same, using both the string as semi-colon seperated and creating 2 temp tables from them.
using

INSERT #Temptablename(Column)
SELECT CAST(DATA AS INT) from SplitString('30:50:60',':')

From there on it was quite simple to insert them along with some other values to the appropriate table as u had already posted.

Thanks a ton again.
shivprasads 30-May-13 2:22am View    
thanks for the reply.

well that is something I already tried but it gives me an error at runtime that read:
"Misused header name. Make sure request headers are used with HttpRequestMessage, response headers with HttpResponseMessage, and content headers with HttpContent objects."

Alteast "ContentTpe" was being accepted by DefaultRequestHeaders.Add() so I thought it may be more proper way of doing that.
shivprasads 29-May-13 8:32am View    
below is the json string
{"currentPassword":"abcd123","email":"abc@example.com","newPassword":"987qwe"}


there is also one optional field that is not passed here.
or does that also needs to be passed as empty value?