I have a table with values for a start and end date. If the start and end date is not the same, I want to duplicate the rows for the dates in between, so that each date has his own row with the same information. Of course I have read many solutions, but could still… Read More Adding row for every date between two dates in SQL
I have this SQL query in SQL Server for context. SELECT O.OrderID, SUM(P.Quantity) AS SprayGlueCans FROM FCMDB.dbo.FcoOrders O JOIN FCMDB.dbo.FcoStyleGroups SG ON SG.OrderID = O.OrderID JOIN FCMDB.dbo.FcoProducts P ON P.StyleGroupID = SG.StyleGroupID WHERE P.CatalogProductID = 12715 AND O.Shipped = 1 AND MONTH(O.ShipDate) = 8 AND YEAR(O.ShipDate) = 2023 AND O.InstallerID <> 3 AND InstallerID <>… Read More Not equal to number does not include null SQL Server
I have a query as declare @aa varchar(50) set @aa = concat(””,year(getdate())-67,””) select * from dimcustomer where cast(datepart(year,BirthDate) as varchar(50)) = @aa I have datatype for birthdate as varchar(50). But unable to get any results, getting zero records What is the wrong with my query ??? help is appreciated !!! >Solution : First, do NOT… Read More SQL query not getting correct result in declare set statement in tsql
I’m looking to flatten my current table. At the moment I was able to achieve this through an iterative approach but the run time is very poor. I queried the table and then used a cursor to iterate and insert into a new table. My current table has many many columns and I’m trying to… Read More Convert table to key value pair
I have problem with my sql query. I want to join 2 table, with condition using where ‘id_pegawai’ and ‘status’ = 1. Table1: SELECT * FROM form_pertambahan_anak Table2: SELECT * FROM peg_dtl_anak WHERE id_pegawai = ‘0000000360’ My Query: SELECT fpa.id_pegawai, fpa.tanggal_pengusulan, fpa.id_anak, pda.id, pda.nama_anak, fpa.deleted_at, fpa.status FROM form_pertambahan_anak fpa INNER JOIN peg_dtl_anak pda ON pda.id_pegawai… Read More Query SQL Server for JOIN and WHERE
I need some help in writing a query which will return the distinct count of memberid who are active YTD and by each month i.e. 202201 – distinct memberid who are active in 202201 202202 – distinct memberid who are active between 202201 – 202202 202203 – distinct memberid who are active between 202201 –… Read More SQL for selecting YTD active member by month
Does anybody know how to hide specific things from this menu? I want my columns be at number one priority, followed by functions and constants. I don’t need all this system variables there. In Visual Studio I can show those entries by category. Does a feature like this exists for the SQL Server Management Studio… Read More Hide items from autocomplete menu in SQL Server Management Studio
In an ORDER BY, I am splitting the first number a column into a separate entity so that I can do some specific ordering. example: Slices 2 14 1 14 5 14 4 14 35 2.6 separated into NumSlice DiameterofPies 2 14 1 14 5 14 4 14 35 2.6 I’m accomplishing this by: LEFT(SLICES,… Read More Why is my SQL LEFT CHARINDEX result only being ordered by the first character?
public class MythreadM { public static void main(String[] args) { // TODO Auto-generated method stub Msg m = new Msg(); Mythread thread1 = new Mythread(m); thread1.start(); Mythread thread2 = new Mythread(m); thread2.start(); Mythread thread3 = new Mythread(m); thread3.start(); } } class Mythread extends Thread { private Msg m; Mythread(Msg m) { this.m = m; }… Read More Thread synchronizing – almost same expressions but different result
Using Microsoft SQL Server Management Studio 18. I have somehow lost the run button on my toolbar, along with the dropdown to select what database I am running my script against. I now have to work with a remote Azure database and would really like having that dropdown showing what context I am in. This… Read More Missing run button and use dropdown from SSMS?