JeremyU | SQLServerCentral

JeremyU

Forum Topics Started

Viewing 15 topics - 1 through 15 (of 57 total)

Topics

Posts

Last post
Logic similar to EXIST to make all values the same if it meets a criteria

3 replies

1 year, 2 months ago

By: JeremyU
Count only unique dates from a subquery

3 replies

1 year, 11 months ago

By: ScottPletcher
Extract value before one symbol and stop after another one in SQL

4 replies

2 years, 1 month ago

By: ScottPletcher
Out of 3 same/ similar rows, remove two and keep one

17 replies

2 years, 2 months ago

By: wbailey
Extracting multiple fields from one column

4 replies

2 years, 4 months ago

By: Jeff Moden
Calculate a sum based on time periods in CASE statement

2 replies

2 years, 4 months ago

By: JeremyU
How to return '0' for no rows (no information) in the table

6 replies

2 years, 4 months ago

By: JeremyU
COUNT DISTINCT OVER PARTITION BY

2 replies

2 years, 5 months ago

By: JeremyU
STUFF XML PATH + Partition By

18 replies

2 years, 7 months ago

By: Jonathan AC Roberts
IF EXISTS + temp table or CTE

10 replies

2 years, 7 months ago

By: JeremyU
What does date show?

5 replies

2 years, 8 months ago

By: Jeff Moden
LAG function + AVG combined

10 replies

2 years, 8 months ago

By: JeremyU
Proper CASE statement

4 replies

2 years, 9 months ago

By: JeremyU
Left outer join + CTE

2 replies

2 years, 9 months ago

By: JeremyU
Selecting temp tables & CTEs using PowerBI

4 replies

2 years, 9 months ago

By: Emperor100

Viewing 15 topics - 1 through 15 (of 57 total)