Viewing 15 posts - 1,846 through 1,860 (of 2,645 total)
As PROD.cost is a float, I think all values in the expression will be converted to float to do the calculation.
January 4, 2019 at 10:04 am
Worth reading this as you are using SQL Server 2016: https://docs.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database?view=sql-server-2017
January 4, 2019 at 8:55 am
I need to...
January 4, 2019 at 6:30 am
I'm a bit thrown off because I am...
January 3, 2019 at 10:20 am
You can also do it with a CTE and ROW_NUMBER():;WITH CTE AS (
SELECT
b.Period AS B_Period,
a.SomeValue,
ROW_NUMBER() OVER (PARTITION BY b.Period ORDER BY a.Period DESC)...
January 3, 2019 at 9:47 am
January 3, 2019 at 9:42 am
January 3, 2019 at 8:59 am
CREATE TABLE #TableA (Period CHAR(7), SomeValue INT) January 3, 2019 at 8:43 am
I'm not sure why it's taking so long but have you tried using INTERSECT? It might be as fast as breaking the query up:SELECT *
FROM...
January 3, 2019 at 8:29 am
Can someone confirm this please - my thoughts are that SQL has 3 main components...
January 1, 2019 at 6:16 pm
If he has a script for his stored procedure he can make it so it just alters the stored procedure if it already exists or creates it then alters it...
December 31, 2018 at 1:16 pm
December 20, 2018 at 1:15 pm
I really like this script. Just been using it to create definitions or temporary tables that have been created using INTO #... which later had a problem with NULL columns...
December 20, 2018 at 9:13 am
December 18, 2018 at 8:06 am
December 18, 2018 at 7:21 am
Viewing 15 posts - 1,846 through 1,860 (of 2,645 total)