2013-03-11 (first published: 2013-02-20)
2,075 reads
Date
Need the First Tuesday Beyond Y days after X Date
A task was set before our team to find the first Tuesday after 10 days from a specific date. This article shows how we accomplished that.
2011-10-13
1,549 reads
Convert seconds to a timestring
This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'
2010-05-05 (first published: 2010-04-28)
1,410 reads
Date Calendar
Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
2019-04-15 (first published: 2009-10-06)
15,119 reads
Return X Day of Month
This function will return the first, second, third, fourth or last day of a given month.
2009-03-03 (first published: 2009-02-10)
1,147 reads
RE: Transactional replication. distribution agent failing
As soon as the distribution agent starts delivering all transactions the log will be clearing but the size won't be reduced.
2005-04-01
RE: trace
Okay. Just went through this several weeks ago. This ended up being my solution. Because of the amount of events that I'm tracking I had to create a stored procedure because the set events went beyond the length of the Jobs window. Here is the header for the stored procedure. First step is to output […]
2005-03-30
RE: Using DTS to FTP data to mainframe
"As per my experience, uploading file by natual DTS is so flexible. For example, the file name is not allowed to changed. "The name of the file can be changed by using the Visual Basic Active X Script functionality within DTS. Just send the output of the text file destination icon to the active x icon and […]
2005-03-30
RE: Assigning a select to 1 view to a user make him see all my objects?!!
HelloSQL Authentication, its normal user not belong to any group its a son of SQL server only I've just create it in Logins in EM and assigened it to 1 view only, Acctually he can read the data from that view, but also he can browse the whole other views design, even all DTS logic […]
2005-03-25
Converting Query Results to Negative Numbers -- Totalling Results
I was given the following example to convert data to negative numbers in a given condition:SELECT RecordType, CASE WHEN RecordType = 20 THEN (Quantity_Ord * -1) ELSE Quantity_Ord END AS Quantity_Ordered FROM TABLENAMEIt works great, but I also need to total the results. When I tell it to sum the quantity_ordered column, SQL keeps giving […]
2005-02-24
4 reads
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers