Viewing 15 posts - 496 through 510 (of 7,168 total)
Note too that the path you provide to the Excel file is from the perspective of the server.
January 15, 2016 at 9:45 am
John Mitchell-245523 (1/15/2016)
You can avoid this by considering which direction your many-to-one relationship goes in before writing the query, or you can write your query in a different way.
The MERGE...
January 15, 2016 at 9:41 am
guy 1966 (1/15/2016)
Ok, I finally found what I neededUPDATE `categories_images` SET `categories_image`=REPLACE (`categories_image`,'.gif','');
UPDATE `categories_images` SET `categories_image`=REPLACE (`categories_image`,'','');
Thank you!
@guy1966, I am not sure why you insisted on getting an answer for...
January 15, 2016 at 9:34 am
Option 3, I have found, is the simplest to understand and let's you handle an entire "record" (ie the primary parent and all children) as a unit of work but...
January 15, 2016 at 8:51 am
nm.rajesh (1/14/2016)
January 15, 2016 at 6:51 am
Typically looping and cursors are to be avoided but in cases where you must call a procedure once for each row for a relatively small number of rows it is...
January 15, 2016 at 1:40 am
1000 is actually not much at all. Yes, again, you need to call the proc 1000 times to send a separate email to eaxh recipient. Do you have the emails...
January 15, 2016 at 1:15 am
Calling the proc once for each email is the supported way. If you need bulk mailer capabilities and performance then Database Mail might not be right for you.
January 14, 2016 at 10:28 pm
You need to call sp_send_dbmail once for every email you want to send.
January 14, 2016 at 9:55 pm
I might be missing something, but why not this:
Setup:
USE tempdb;
IF EXISTS ( SELECT *
FROM ...
January 14, 2016 at 9:53 pm
Fair enough. The topics on which I would like to do a deep dive with you someday just keeps on growing.
January 14, 2016 at 9:37 pm
When you go to Services do you see two "Integration Services" services, e.g. "SQL Server Integration Services" which would be from SQL 2005 and "SQL Server Integration Services 11.0" which...
January 14, 2016 at 9:25 pm
b_boy (1/14/2016)
What they expect from the new DW, is to have these new fields created imported and available for reporting.
Are your custom fields stored in a EAV structure? In what...
January 14, 2016 at 9:21 pm
See if this gets you close:
SELECT sp.StudentID AS [@id],
(
SELECT 'final' AS type,
...
January 14, 2016 at 9:13 pm
Jeff Moden (1/14/2016)
January 14, 2016 at 2:19 pm
Viewing 15 posts - 496 through 510 (of 7,168 total)