Calendar Table by Interval Minutes
Populate a calendar table with user set interval start and end datetime values.
2015-03-24 (first published: 2014-02-21)
1,888 reads
reporting
RE: Unable to connect to the remote server error
HiIm also getting the same error while trying to access the report manager.Please help if any one find a solution for this.Thanks
2005-04-28
RE: Leap Year got Me ... Help!
IF ISDATE(CAST(DATEPART(YEAR, GETDATE()) AS CHAR(4)) + '-02-29') = 1 BEGIN PRINT 'Leap year' END ELSE BEGIN PRINT 'Not a leap year' END
2005-01-19
RE: DTS and "Flags"
Hi, Happy New Year There are two very basic options. The first is to generate a DTS package that performs all the tasks you need, alternatively, you could split the tasks into smaller DTS packages and schedule them as ‘Jobs’ (under management folder (if using 2000)). In both options you have a precedence order so […]
2005-01-05
Hot Standby Solutions
DBAs,Does anyone know of other hot standby solutions for SQL Server besides failover clustering? Are there any 3rd party tools available?Thanks.
2004-10-01
1 reads
Is there an equivalent function in RS to Crystals "Next" command
I am converting a report from Crystal to Reporting Services and I need the ability to look ahead by one row (the Next command in Crystal) and use this data from the result set to perform certain calculation.If there is not a similar comman is there a way to do this short of creating a […]
2004-09-22
1 reads
RE: Creating a batch file to run multiple SELECT statements and output to a csv file.
Hi DavidThank you very much for the info.An example would be good as I am new to SQL programming.
2004-09-13
RE: DTSLookups Array is null ?
In general, lookups are performance killers in DTS packages. If I were using DTS against millions of records, I'd not use a lookup. Could you add the foundkey in your source SQL?
2004-09-08
2 reads
Data for Source too large for specified buffer size
I am importing an excel file into a SQL Server table using data transformation task. I get the error, Data for source column 25('internal comments') is too large for the specified buffer size. I went to the advanced tab and increased the buffer size to '2' , however only one line is then inserted. I […]
2004-03-19
28 reads
RE: Updating multiple rows.
QUOTE:I have a personal details table and a table that records an individuals transactions through a process. Each time a new record is added to show a new transaction I want the trigger to ensure that all previous transaction records for that individual have a record status of R leaving the new record as the active […]
2004-03-19
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
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...
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