Forum Replies Created
Viewing 15 posts - 196 through 210 (of 10,144 total)
-
RE: Slow SQL Script
Here's a slightly more conventional form of the same query just to get us started really. Please can you run it, confirm that it generates correct results, then post the...
-
RE: poor performing report query against table without a PK
Create this index and check out the plan. I'd expect to see a seek for the date and residual predicate for the remaining filter columns, then a key lookup to...
-
RE: poor performing report query against table without a PK
Grant Fritchey - Monday, November 26, 2018 8:11 AMChrisM@Work - Monday, November 26, 2018 8:06 AMRE: poor performing report query against table without a PK
Jonathan AC Roberts - Monday, November 26, 2018 7:52 AMRE: Inner joins
andycadley - Sunday, November 25, 2018 2:48 PMRE: poor performing report query against table without a PK
polkadot - Sunday, November 25, 2018 11:02 PMRE: High memory utilization on SQL Server
sqlguy80 - Sunday, November 25, 2018 6:48 PMRE: pivot with group by
tanehome - Thursday, November 15, 2018 2:41 AM
Hi All,
I need your assist in a simple query to pivot the below...RE: Creating a Stored Procedure with Loop and If statement into a new table
roy.hoult - Tuesday, November 13, 2018 12:10 PMRE: SQL Query Delete top 4000 rows when row count > 10K looping to reduce row count to 10K
epivaral - Tuesday, November 13, 2018 10:33 AMRE: SQL Query Delete top 4000 rows when row count > 10K looping to reduce row count to 10K
register 33943 - Tuesday, November 13, 2018 9:38 AMRE: character data type selection in table design
What's wrong with 'Y' and 'N' as CHAR(1)? Unlike 0 and 1, there's no chance of getting them the wrong way around (I've seen this!!). You could even make it...
RE: Running query with Actual Execution Plan On slows down the query?
Jonathan AC Roberts - Tuesday, November 13, 2018 7:41 AMRE: Creating a Stored Procedure with Loop and If statement into a new table
If you really need the table CIP_updated_dateTOBE then use this:
;WITH FirstSelection AS (RE: Creating a Stored Procedure with Loop and If statement into a new table
Something like this:
;WITH FirstSelection AS (
SELECT
[TB_Code],
[TB_Start_production],
[TB_Resource_Code],
[TB_Version],
[TB_Start_Changeover],
[tb_duration_changeover],
[id] = ROW_NUMBER() OVER(ORDER BY TB_Resource_code ,TB_Start_production),
CIP_END,
[END_CIP] = CONVERT(char(5), DATEADD(MINUTE, tb_duration_changeover,...Viewing 15 posts - 196 through 210 (of 10,144 total)
