In you sql code add this line CASE WHEN Approach = 0 THEN NULL END AS Approach so in your stored procedure when Approach will come as 0 then it will be replaced with NULL solved How to modify stored procedure to give null instead of 0
I finally solved the problem by rebuilding my TCP/IP stack, using Netshell from a Command Prompt window. Apparently I was getting a TCP/IP timeout. netsh int ip reset c:resetlog.txt http://support.microsoft.com/kb/299357 1 solved ASP.NET MVC Debugging Very Slow – SQL Server Express Connection Issue?
select ID, — returns a sequence without gaps for consecutive years first_value(year) over (partition by ID order by year desc) – year +1 as x, — returns a sequence without gaps row_number() over (partition by ID order by year desc) as rn from Temp e.g. for ID=1: 1 2016 1 1 1 2015 2 2 … Read more
You can do it using XQuery SELECT [TO] = t.XmlColumn.value(‘(ParameterValues/ParameterValue[Name/text() = “TO”]/Value/text())[1]’, ‘varchar(100)’) FROM YourTable t / is a child node navigation. [] is a predicate test on a particular node. So this looks for ParameterValues/ParameterValue which has a Name child with text TO and returns the Value child’s text. Note the use of text() … Read more
Your query executes an INSERT (IE. Adds data to your table) It doesn’t retrive any record. The INSERT statement in T-SQL could use a SELECT subquery to feed the values that are requested by the columns listed after the INSERT. So your query add a new record every time you run it, but there is … Read more
Solution is very simple – need to add: Database=myDataBase; to CONN_STR = ‘DRIVER=SQL Server Native Client 10.0;UID=user;PWD=pass;server=server;’ + ‘Trusted_Connection=No;MARS_Connection=yes’;Database=myDataBase; Thanks Arnaud for great framework!!! solved Delphi: What’s wrong with REST API based on mORMot?
Posting as an answer, because I have a LOT of comments: The RIGHT JOIN is certainly wrong. This would imply that some stores do not need to exist, but of course, your sales facts are tied to stores with an INNER JOIN. It is effectively being turned into an INNER JOIN anyway, so is unlikely … Read more
If you don’t want to create a dedicated function, you can use successive CROSS APPLYs: SELECT T.s, FirstSpace.i, SecondSpace.j, ThirdSpace.k, CASE When ThirdSpace.k > 0 THEN LEFT(T.s, Thirdspace.k – 1) ELSE T.S END AS Phrase FROM t CROSS APPLY (SELECT CHARINDEX(‘ ‘, T.s, 1)) AS FirstSpace(i) CROSS APPLY (SELECT CHARINDEX(‘ ‘, T.S, FirstSpace.i + 1)) … Read more
For the week number you can use PARTDATE() function, So you query should be : select partdate(WK,r.date) numweek, sum(r.sales) totsales from yourtable r group by partdate(WK,r.date) Take a look please at Get week number from dates in T-SQL You can also subtruct an N numeric value from partdate(WK,r.date) and then beware of group by clause, … Read more
Yes, it’s possible to access the web server from an external network, depending on your current network configuration. There are two simple solutions I think would suit you. Configure your firewall if needed, enable port forwarding in your router settings to forward port 80 to the internal IP of the machine running your XAMPP-server. If … Read more
Pseudo code is just a way to express the intent of the program without being syntactically correct. An example could be: print “What is your name” read input from user print “Hello ” + user input Another example for withdrawing money from an ATM: if the selected account’s balance is greater than the requested amount … Read more
I think the issue is that you have an extra space after the inserted text in the SQL. This means that you are effectively searching for “lblheader.text ” (with a space after it) everytime, which I doubt is what you want. In the SQL statement , change LIKE ‘%”+ lblheader.Text +” %’ “; To LIKE … Read more
Maybe this… get the maximum sum for each city and menu item name. Top returns 1 row not one row per group. you need to use the max aggregate to make this work the way you want. you can’t double aggregate max(sum(Quantity)) so you have to either use a sub select, or use a CTE … Read more
MSSQL doesn’t have a direct md5 function (you can convert it as demonstrated here). You need to use it through PHP like so: $sqla = “INSERT INTO users (username, password) VALUES (‘rob_dewar01’, ‘” . md5(‘KingDozer’) . “‘)”; Also, md5 is not secure. Look into using prepared statements. See the Secure hash and salt for PHP … Read more
This is a classic Relational Division With Remainder question. You just need to frame it right: You want all Tasks… … whose TaskTags divide the set of all UserTags for a given User There can be a remainder of UserTags but not a remainder of TaskTags so the former is the dividend, the latter is … Read more