I think you need to use a case statement for the value. Below is just off the top of my head, so you may need to use full join if that doesn’t work. select t1.date, case when t3.IDCLIENT is not NULL then t3.value else t2.value end as Value from Table1 t1 inner join Table2 t2 … Read more
I’m not sure you can do that the way you’re trying, Why don’t you load the image into a variable then use that variable in your insert statement: declare @image varbinary(max) set @image = (SELECT BulkColumn from Openrowset( Bulk ‘C:\Users\Yassine-Kira\Desktop\Templates\ProductImg\elite-book_tcm_133_1096796.png’, Single_Blob) as BikeImage) insert into dbo.Produit values (‘Pc portable’, ‘HP EliteBook série p’, ‘Un ordinateur…’, … Read more
update table1 set numberfield = numberfield – 7 if numberfield is 30, then numberfield = 30 – 7, difference will be the new value of the field
A Cartesian join (note there is no JOIN condition). All possible combinations of records are in the results: tableA (charfield Char(2)) tableB (numberfield Number(1)) INSERT ‘A’ INTO tableA; INSERT ‘B’ INTO tableA; INSERT 1 INTO tableB; INSERT 2 INTO tableB; SELECT * FROM tablea CROSS JOIN tableb Results: charfield|numberfield ===================== A |1 A |2 B … Read more
You can use a running, conditional MAX to get the latest datetime value when value = 2. You can exclude the current row by using ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING SELECT t.id, t.value, t.datetime, datetime2 = MAX(CASE WHEN t.value = 2 THEN t.datetime END) OVER (PARTITION BY t.id ORDER BY t.datetime ROWS BETWEEN … Read more
EDIT From SQL Server 2012 and later you might use the FORMAT function if you want to force a date into a formatted text: https://msdn.microsoft.com/en-us/library/hh213505.aspx With earlier versions you might use something like this: DECLARE @d DATETIME=GETDATE(); DECLARE @TargetFormat VARCHAR(100)=’DD/MM/YYYY’; SELECT CONVERT(VARCHAR(100),@d, CASE @TargetFormat WHEN ‘MM/DD/YYYY’ THEN 101 WHEN ‘DD/MM/YYYY’ THEN 103 –add all formats … Read more
The query you require is a very simple SQL statement using the GROUP BY clause. Because you are asking information that needs grouping by date only and also information that needs grouping by date and by technician you should use GROUPING SETS. select year(closed) as year , month(closed) as month , Technician , count(*) as … Read more
SELECT *, NULL AS Field4 FROM TableA WHERE Field1 NOT IN (SELECT Field1 FROM TableB) UNION ALL SELECT * FROM TableB
The documentation you mentioned specifies what happens: “[…] throw an exception when its minimum or maximum value is exceeded” Regarding the error message you can find out using a simple Google search: https://www.google.com/search?q=t-sql+error+messages+sequence The fourth link is https://www.sqlshack.com/sequence-objects-in-sql-server/ and there you can find a screenshot of the error, which has the number 11728. Of course, … Read more
That table is really a very bad design. Anyway, here you have the code. It uses dynamic sql: DECLARE @sql nvarchar(max) SET @sql = N’CREATE TABLE TheMostStupidTableIHaveEverSeen(ID int, Name varchar(100)’ DECLARE @i int = 1 WHILE @i <= 598 BEGIN SET @sql = @sql + N’, A’ + CAST(@i AS nvarchar(4)) + N’ int’ SET … Read more