Hi Guys I am trying to understand how to save and edited row to the database private void BudgetGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e) { SqlCommand gridcmd = new …
Select from two tables with group by date
I have two tables: Table t1: So from this table I want to get count field Id for each day. For this I use next query: It’s work good. So next table is t2. To select data by date from this table I use next query: It’s also work good. So my purpose is merge these two queries into one
Select all rows and ignore the first row
I’m currently using the following SQL query which is returning 25 rows. How can I modify it to ignore the first row: I’m using SQL Server 2008. Thanks. Answer You can use EXCEPT in SQL Server 2008. For SQL Server 2012 and above, you can use FETCH OFFSET
Convert iso_week to calendar date in SQL
I’ve been searching though the archives without finding what I am looking for- I’d be happy for some guidance. I have a data set where I want to report aggregated number of appointments by provider (STAFFID) and work week, the latter defined by the week’s Monday date. I’ve played with …
Update a single column on multiple rows with one SQL query
I need to update a single column over a thousand rows in the database. Normally when I need to do this, I’ll do the following: I feel like there should be a way to do this easily, but after searching around online, I cannot find a solution. What I was hoping for was this: An important piece of informati…
I want a single query that deletes duplicate entry from my database
I have written a query delete from Table1 where Tableid in(select Tableid from Table1 group by Tableid having count(*) >1) but this query removes all the data having count greater than 1. Can …
the row values updated or deleted either do not make the row unique or they alter multiple rows
I want to delete row and I get this error: the row values updated or deleted either do not make the row unique or they alter multiple rows Answer There are duplicate rows in your table. When this is the case you cannot edit table using UI. first delete rows with matching data using SQL then try and edit. Dele…
Add an autoincrementing ID column to an existing table with Sqlite
Using Sqlite, I want to add an auto-incrementing ID column to an existing table which had previously no ID: How to do it properly? I have this error: sqlite3.OperationalError: near “auto_increment”: syntax error Answer An SQLite table cannot modified in a significant manner using alter table once …
LAG functions and NULLS
How can I tell the LAG function to get the last “not null” value? For example, see my table bellow where I have a few NULL values on column B and C. I’d like to fill the nulls with the last non-null value. I tried to do that by using the LAG function, like so: but that doesn’t quite wo…
how to get the ID of the record that is update in C#
I am able to get a sql query that can return the ID of a record that is update in the Database; that ID is needed to update other records. but I don’t know how to get that updated ID value in C#. Answer I think you’re really asking how do you retrieve the resultset returned by an INSERT or