Automating population of SQL Server data into Word and PDF document templates for contracts, invoices,letters etc. creation saves thousands of hours for businesses. This article explores various approaches and offers few suggestions on how to choose the best approach for your requirements.
2018-10-08
6,905 reads
How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.
2015-08-21 (first published: 2013-05-08)
28,103 reads
How do I go about taking two tables from two databases (with same column names) and make it look like one table? I need to do this with a query and not moving data from one db to another. HELP!!!!Database1 ID LastName FirstName 1 Lee Terry 2 Something Anything Database2 ID LastName FirstName 1 Smith […]
2005-04-27
If you're presenting the results of this query on the web, you might need to use a align="right" tag and this will format the number to TWO decimal places:<%=FormatNumber(rs("BD_TR_AMT"),2,-1)%>Hope this helps.
2004-07-30
What do the last few lines of your sqlstp.log report? It should be in %SYSTEMROOT%. You can go from SQL Server 2000 RTM (the CD) straight to SP3 without applying the others.... the Service Packs are cumulative.As for the initial question, we're running Win2K3/SQL2KSP3 Active/Active. Experiencing some issues with distributed transactions and MS DTC, but we're […]
2004-02-05
Trace yourself in profiler while you look at the jobs.. That should give you an idea of the permissions you need. Without testing anything I am guess readonly permissions in msdb will do the trick.
2004-01-30
1 reads
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
It’s a great question. Let’s say you want to capture stored procedure completions. But,...
By Steve Jones
I got this in an email about a week ago from the PASS Data...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers