One should not be too surprised that a query typed right out of the blue does not return anything.
The best way to get help with a problem like this is to post:
1) CREATE TABLE statements for your tables.
2) INSERT statements with sample data, enough to demonstrate the problem.
3) The desired output, given the sample.
4) A short description of the business rules which explains why you want that output.
5) Which version of SQL Server you are using.
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
No comments:
Post a Comment