What?
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource.
Why?
If you are simply using a text file as your data source, then ...
What?
So this is an article to serve as documentation for one of the data sources available to download for FREE from this site.
Why?
It's useful to have a CSV list of all the IP ranges and their ...
... -- SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100)
SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ...
... -- SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100)
SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ...
...
This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells.
Display all Unique
Found this note on one of Microsoft Help sites:
Office 2010:
Select the ...
Why?
I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able ...
... number my bosses want - 7h 24m or 26640s is 1 person day)...
With date range as parameters
...ouch...
...and it was so easy up to here...
Tables of interest
StaffActivities
...
So I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in ...
... customer], resolved, postponed)
--- Progress Indicator (red, green, orange)
--- Create Date / Modified Date / Due Date / Expected Completion Date / Expired Date
--- Display status for: public, registered, ...
Situation
The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just ...
... range. The problem is that there are a few thousand users and Microsoft's SQL Server Reporting Services interface isn't the most fun to scroll endlessly down. Advanced users can type the name really fast ...
... AS (
--Select First hour in range
SELECT CONVERT(DATETIME,@StartTime) AS [Time]
UNION ALL
--Add a record for every half-hour in the range (change based on slot times)
SELECT DATEADD(MI, ...
... AS (
--Select First day in range
SELECT CONVERT(DATETIME,@StartDate) AS [Date]
UNION ALL
--Add a record for every day in the range
SELECT DATEADD(DAY, 1, [Date]) FROM Dates WHERE Date ...
... Union or MoneyGram. These services are not meant for transactions between strangers. In our experience they’re favoured by fraudsters. One popular trick is to ask you to prove that you have funds by sending ...
... in order to tweak the program to suit your needs.
Launcher v2.0 is crude replacement to the quick launch toolbar which arranges your icons in a grid that you define (the default is 7x7). Change the ...
... should see a list of visual effects, some of which will be unchecked if you are not experiencing the full range of Aero features.
Select the custom option and then select all the effects from the ...
... screenshots.
Service Level Agreement
Post-project support to be arranged prior to launch
Discuss expectations for changes and support (response times)
Critical - nothing ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.