Report Parameter Date Range
A forum poster wanted to use a StartDate parameter to limit the range of dates available
in a second parameter to...
2010-03-11
532 reads
pturley
Self-Service Reporting Best Practices on the Microsoft BI Platform
Article from the Architecture Journal ? 12-15-2009
by Paul Turley
Once upon a time, there was a big company whose IT department
wanted...
2010-03-11
859 reads
Showing User-related Content in a Report
In cases where you want the data or content in a report to be different for each user,
there are a...
2010-03-11
531 reads
Using a Report Subscription with User Authentication
This question comes up quite often. A report requires a user to be authenticated using
their own network user name and...
2010-03-11
400 reads
Blogs
T-SQL Tuesday #181: A Technology Present
By Steve Jones
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...
Trace Flag 3625 Follow Up
By Patrick
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Forums
Group records during capture
I have a table which is being written to by another application. A few...
Peer review SQL Central articles
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Getting ANY of the data
Comments posted to this topic are about the item Getting ANY of the data
Question of the Day
Getting ANY of the data
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers