Displaying a Check Mark for a Row When a Related Record Exists
Let's say that you have a column
named some_id in an outer-joined table that will return a value if a record...
2010-03-11
405 reads
Let's say that you have a column
named some_id in an outer-joined table that will return a value if a record...
2010-03-11
405 reads
You can define a calculated field for the datset outside of the query using a Visual
Basic.NET expression. In the Data...
2010-03-11
662 reads
On the MSDN forums I see a lot of questions about how to use program code or command
line script to...
2010-03-11
489 reads
What lessons have we learned about managing report projects and what are the best
practices?
Since each report is stored in a...
2010-03-11
1,234 reads
How should date type parameters be prompted? There are two common approaches
depending on how you want the parameter to appear. ...
2010-03-11
381 reads
When using the Jump to Report action int he web browser, the target report is displayed
in the same browser window...
2010-03-11
426 reads
Report designers often revert to overly complex report designs and often use subreports
unnecessarily. Building a report on a single dataset...
2010-03-11
572 reads
I've decided that from now on, consulting project estimates will be padded for an
additional week to get Oracle connectivity working...
2010-03-11
443 reads
Top ranked lists are a common type of report. In many cases business users may want
to see only a specific...
2010-03-11
648 reads
A forum poster wanted to use a StartDate parameter to limit the range of dates available
in a second parameter to...
2010-03-11
528 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers