Tag: statements

I'm having a weird issue with IDENTITY_INSERT & am at a loss. Can anyone see what I'm missing?

I’m getting an error when trying to execute the following statements complaining that IDENTITY_INSERT must be on in order for the insert to occur, but I am turning it on. SET IDENTITY_INSERT Thompson_GDM.dbo.employees ON GO INSERT INTO Thompson_GDM.dbo.employees SELECT [EmployeeId], [AssignmentId], [more columns…] FROM TMLAVSQLBIS.ThompsonMachinery.dbo.Employees; GO SET IDENTITY_INSERT Thompson_GDM.dbo.employees OFF go The error message is… Read More I'm having a weird issue with IDENTITY_INSERT & am at a loss. Can anyone see what I'm missing?

MRLeave a comment

how to calculate date range correctly using arrow in python

I have the small snippet of codes below, I am trying to calculate the number of days between today and yesterday using arrow and make sure the result is accurate. import arrow TODAY = arrow.now() YESTERDAY = arrow.now().shift(days=-1) result = TODAY – YESTERDAY print("result: ", result) print("number of days: ", result.days) print("TODAY: ", TODAY) print("YESTERDAY:… Read More how to calculate date range correctly using arrow in python

MRLeave a comment

Using elif statement "print function" not working correctly instead printing if statement's "print function" instead

I am trying to make a selection tool to pick my next anime, I used the random package to select which one would be the next to watch and this works correctly my issue lies in the following I want to add a description to the selected show, for example, if it picks show b… Read More Using elif statement "print function" not working correctly instead printing if statement's "print function" instead

MRLeave a comment

C# Function Overloading in the New .NET 6 Console Template is Not Working

I am getting errors trying to overload the function Print(object) in the new .NET 6 C# console app template (top-level statements). void Print(object obj) => Print(obj, ConsoleColor.White); void Print(object obj, ConsoleColor color) { Console.ForegroundColor = color; Console.WriteLine(obj); Console.ResetColor(); } Errors are: From Print(obj, ConsoleColor.White) -> No overload for method Print() that takes 2 arguments From… Read More C# Function Overloading in the New .NET 6 Console Template is Not Working

MRLeave a comment

more concise way to make this?

I’m unsure of how to create a certain section of my code without it being excessively long and tedious. Is there perhaps a way of utilizing a range function where I need my elif statements? Any help shortening this would be more than appreciated! #just some sample lists Player.PlayerList[1].carrier_row = [0,1,2,3,4] Player.PlayerList[1].carrier_col = [5,5,5,5,5] Player.PlayerList[1].battleship_row… Read More more concise way to make this?

MRLeave a comment

How do I produce a new column with values based on a Partition of one column while also based on the values of two additional columns (BigQuery)?

I have a table that records all the different statuses for a list of Jobs with timestamps. So the ID column has many Ids that appear several times as their status changes such as with the ‘xyz’ job below that went through several status changes. JobId Status Timestamp xyz pending 1:00 xyz reviewed 1:02 xyz… Read More How do I produce a new column with values based on a Partition of one column while also based on the values of two additional columns (BigQuery)?

MRLeave a comment

Update statement is no query?

How do I define the update statement in the orm.xml. I have it as a named-query and everything works, but my teacher said that an update statement isn’t a query. I have tried a native query, but that wasn’t working. ORM-Type: <?xml version="1.0" encoding="UTF-8"?> <entity-mappings version="1.0" xmlns="http://java.sun.com/xml/ns/persistence/orm&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm orm_1_0.xsd"> Update Statement: <named-query name="updateTshirts"> <query>… Read More Update statement is no query?

MRLeave a comment