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
Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.
2019-04-15 (first published: 2012-03-19)
6,358 reads
Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.
2010-09-03 (first published: 2010-08-27)
2,640 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
I am Sorry....... The table has two fields; Last Name, First Name.In the view I want Last name and first name into one field.Thanks
2004-09-03
Can you reboot? I've seent he cursor message, but can't remember what it was. It was awhile ago and I think it cleared itself. As far as diskkeeper, do you exclude the SQL Files? I do and don't have any issues.
2004-05-11
2003-12-05
1 reads
quote: oh, and one more thing - (this is classic) - put in a trigger on the table that will randomly show managers making updates to different manager's data - that'll keep 'em busy... d*mn right. You know, yesterday we closed an options position with a loss of ~6 million €. Call it an insurance […]
2003-07-18
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