Comments by Kristian_dk (Top 39 by date)

I believe that it is yyyymmddhh
I hope that is better.

hi Jamuro77
Thank you very much!! This solution did the trick.
Awsome
/Kristian

okay, point taken! Thanks for helping out

Thanks for tipping in Richard. I was not aware of Encoding. Good learning for me.

I see your point. You are absolutely right. I was simply aiming for consistency in my entire web application. But you are right!

Thanks Prateek - you led me in the right direction :-) now it works

RyanDev.. You are the MAN!! I have tried so many Things and spend now 7-8 hours solving this. You solution is absolutely awsome!! thank you!

Hello RyanDev. I'm a newbie - could you elaborate a little bit on how I do that ?
I have two sql queries. The first one on Webform1 which populates all products and the productnumber. The second sql query is on webform2 which shows all product details. This sql query is based on a WHERE product_no = @product_no
But how do i pass my productnumber from Webform1 into that WHERE statement?
Help :-)

Thanks for helping me. I'll try this tomorrow. ;-)

Thanks for helping out RyanDev. Any specific reasons for not doing it from the sql server side?

I don't understand the code but it really Works! Thanks RyanDev...

The problem is that the query currently returns the results from each SELECT in two datarows:
100800 : 2016
659333,06 : 2016
I need only one row with the two numbers added to eachother.
Any ideas?

Thank you for replying. I also believe that my results are okay, but how do i get the 2016 results added in the end. I have already ensured in my Querys that the results are now in DKK without VAT so i simply need to get
THIS:
100800 : 2016
49402,44 : 2015
659333,06 : 2016

TO BE LIKE THIS
49402,44 : 2015
760133,06 : 2016

I don't know SQL fiddle, but i will learn this for the NeXT time i post an question in here. Thanks for submitting to my question.

Thank you (both of you) for helping out. UNION ALL did the exact trick that i was looking for.

Thank you so much for helping out. This Works!! yehaa

I am constructing this in my asp application by dragging in a DataGridView and then configuring the datasource by a SQL Query.
Hope this makes sense.

is this a ADO.net access?

My connectionstring looks like this:

<asp:SqlDataSource ID="SqlDataSource1701" runat="server" ConnectionString="<%$ ConnectionStrings:WebCrmMsAzureConnectionString %>" SelectCommand="SELECT CAST(SUM(Cust.[Sales (LCY)]) AS decimal(8 , 2)) AS Totalsales, Cust.[Customer No.], Customer.Name, Customer.[Sell-to Type] FROM [Cust. Ledger Entry] AS Cust INNER JOIN Customer ON Cust.[Customer No.] = Customer.[No.] WHERE (YEAR(Cust.[Posting Date]) = YEAR(GETDATE())) GROUP BY Cust.[Customer No.], Customer.Name, Customer.[Sell-to Type] ORDER BY Totalsales DESC">

Richard that actually helped ;-) great - now it Works!

Both of these also Works - and i have decided to include both in my report. Really nice to both post the number and the actual list. Can i challenge you a Little bit.

In the Number of organisations solution, what if I would like to have to numbers. to compare in a chart.
1. The total number of organisations
2. The number of organisations with no contact persons related (as you have already solved)
Then i can make a percentage chart of our dataquality.
Can you help me here?

This Works - i get a list thanks !!!

Thanks for posting two very cool suggestions. Sorry that my question was a Little unspecific. However, non of your SQL code is working against my server.. hmm thats weird

I get at incorrect syntax near keyword 'GROUP'

Sorry i did not think about that :-)

But your code actually works on another SQL server.. hmmm thats weird..

This one was accepted - nice finally i can continue with my project. Thanks for helping

Dosen't work :-( Sql server is returning an error when doing so..

Dosen't work :-( Sql server is returning an error when doing so..

This helped :-) Thanks a lot

Thank for helping out Ryan - your solution was actually correct :-)

Hello Herment, Thanks for helping me out here. I'm not so techincal strong.
The thing is that my IIS is running on a Windows 2003 server which was running .net 2.0 and then i asked him to upgrade it to .net 4.0.
Could this be the issue - and is there anything that should be done to integrate this new .net 4.0 to IIS.
I'm not so happy about uninstalling anything on the server since it is running our Company ERP system.
/Kristian

Hello Ryan. Thanks for helping out.
I have ensured that it is targeting Default.aspx
When i click browse it get a 404 error page without any useful information now. I have tried to deploy the webapp to another server (2012) here i actually works.. Hmm i'm confused

That was exactly what i was looking for.. You have made my day! Thanks!