petervdkerk | SQLServerCentral

petervdkerk

Forum Topics Started

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

Topics

Posts

Last post
Storing user relations with conditional join on other tables

2 replies

9 years ago

By: petervdkerk
Recursive Concatenation of Parent Elements

27 replies

9 years, 3 months ago

By: sgmunson
Get rows and sum in joined table

21 replies

9 years, 6 months ago

By: petervdkerk
The FOR XML clause is invalid in views, inline functions, derived tables, and subqueries when they contain a set operator.

6 replies

10 years, 3 months ago

By: michael.evenson-916214
Adding 2 COUNT statements results in heavy query

7 replies

10 years, 9 months ago

By: TheSQLGuru
Remove duplicates where 3 columns contain the same value

6 replies

10 years, 10 months ago

By: Sean Lange
Count aggregate results per day via SQL

10 replies

12 years, 2 months ago

By: petervdkerk
Conditional select of identical fields from joined tables

3 replies

12 years, 7 months ago

By: CapnHector
Conditionally updating columns cross-table in a very large dataset

19 replies

13 years ago

By: Ninja's_RGR'us
I desperately need query optimization: query already runs for 1.5 days.

6 replies

13 years ago

By: brendan woulfe
Enriching duplicate records (not deleting)

14 replies

13 years, 1 month ago

By: petervdkerk
Exporting data to MS Ecel 2007 results in Error 0xc0202025: Data Flow Task 1: Cannot create an OLE DB accessor. Verify that the column metadata is valid

2 replies

13 years, 1 month ago

By: Jared
Selecting all records that occur more than once

2 replies

13 years, 1 month ago

By: Jeff Moden
Remove duplicates based on occurrences with join on other table

36 replies

13 years, 2 months ago

By: petervdkerk
when joining tables, how to get the max value from same column in the 2 joined tables

1 replies

13 years, 3 months ago

By: petervdkerk

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