Thanks to all, i have worked out with my same query, although seed was slow. query is mentioned below:- select Item, Location,[Transaction Date],Price,Qty, Price_change , (select isnull(sum(qty),0) from #temp c where c.item=p.item and c.Location=p.Location and c.[Transaction Date] < p.[Transaction Date]) [Opening Stock] from #temp p solved MS SQL Query for Opening Stock calculation
Is this what you are looking for? select ProdID, min(Qualified), case when min(Qualified) <> max(Qualified) then ‘YES’ else ‘NO’ end as Has_different_results from VarAnn_Data.dbo.tblOwnership group by ProdID solved Sql Query condition based on column can holded bit
Presumably, you have more orders than you have employees. Hence, one employee is on many orders. When you run: select e.firstname from employees e inner join orders o on e.employeeid = o.employeeid; Then you are getting a list of all first names — so one employee name is going to be repeated, once per each … Read more
Thank you all. I needed to find the common column (the ID column). UPDATE t SET t.Address=”FDAN” FROM TBTest.dbo.Site t INNER JOIN Jobs j ON t.Site_ID = j.Job_ID WHERE j.Job_No = ‘F0085′ I don’t fully understand how the aliases work. But it appears to be working fine. 13 solved Update…Set…From…Where query is affecting all rows … Read more
Following should work .. SELECT decadeBegin, decadeEnd, NumOfMovies FROM dbo.TableOfDecades(); solved using of functions or views in sql
Below query should do the job. Names in the ADDED_BY column seem to be the reference for aggregation in both your columns. SELECT A.ADDED_BY, A.TOTAL_RECORDS_ADDED_BY, COUNT(B.UPDATED_BY) AS TOTAL_RECORDS_UPDATED_BY FROM (SELECT ADDED_BY, COUNT(*) AS TOTAL_RECORDS_ADDED_BY FROM YOUR_TABLE GROUP BY ADDED_BY) A LEFT JOIN YOUR_TABLE B ON A.ADDED_BY = B.UPDATED_BY GROUP BY A.ADDED_BY, A.TOTAL_RECORDS_ADDED_BY; solved SQL Query … Read more
CONVERT(CHAR(10), CONVERT(DATETIME, Created), 103) solved SQL date-format conversion ques
I edited my answer as it didn’t provide enough clarity as pointed out by a moderator as the source link I mentioned could run the risk of being deleted. If you need further clarity, the link will be in this explanation. Ok the a work around was using the guide of this user from here … Read more
The problem is that you are building SQL in the proc, but you are not using the values in @startdate and @enddate, instead you are passing the string You need to grab the values of these variables when you build the string – something like: ALTER PROCEDURE [dbo].[ParkingDeatailsReport] @locid INTEGER, @startdate nvarchar(100), @enddate nvarchar(100) as … Read more
You are trying to insert 5 length character(‘dfdfg’) into your 1 length column [Access] [nvarchar](1). Increase the value of your column in Table type. CREATE TYPE [dbo].[AccessLevel] AS TABLE( [RoleId] [int] NULL, [Access] [nvarchar](25) NULL, [IsDelete] [bit] NULL ) GO solved String or binary data would be truncated when using it in a stored procedure
I’m going to make a few assumptions, but I think I know what’s going on. municipio is probably an empty string. It is not null. In that case, municipio ?? (object)DBNull.Value will be an empty string, not null. However, municipio.Length > 0 ? municipio : (object)DBNull.Value has a value of DBNull.Value, which will generate a … Read more
@fia Maybe you should do your calculation elsewhere first for example on paper or in Excel to ensure you know exactly what you should get. It would also help you figure out the order of the calculation before writing it in SQL. According to the figures shown the values you’ve stated seems to be correct … Read more
Please try the following solution. What we are doing here is called shredding, i.e. converting XML into rectangular/relational format. I am shooting from the hip because DDL and sample data population were not provided. The provided XML is not well-formed due to missing root element, but SQL Server allows to handle XML fragments. We are … Read more
Maybe change the data type on the db to an integer of some sort? Why does this differ from your input? Anyway the below should work. You should always make sure you utilize the parameters property within a SqlCommand to avoid SQL injection. void countVR(int kk) { string selectString = “SELECT COUNT(*) FROM cllohn” + … Read more
I assume that you want to dumb the data from bulk_data to myaccount table, business_setup table and business_info table. if so, Assumptions : – Column names with prefix myaccount_ belongs to myaccount table – Column names with prefix business_setup belongs to business_setup table – Column names with prefix business_info belongs to business_info table – complete … Read more