Thanks, that works nicely especially outputing the log to SQL

General purpose of it is to return object ID based on given name but we use it to check if the object already exists or not before we attempt to...

Thanks, I'll try it.

I don't think that triggers are evil(full stop), they become evil when written by the wrong people, in the wrong manner and for the wrong reasons.

Your task here is to...

My Solution:

SELECT A.ID,COUNT(B.SomeColumn) AS [CountOfB]

FROM @T1 A

LEFT JOIN @T2 B ON B.SomeColumn = A.ID

LEFT JOIN @T2 B2 ON B2.AnotherC = A.ID

GROUP BY A.ID

That should perform better and as it...

Why you are using SUM and CASE to count not null rows? Just use COUNT instead on a specyfic column and you will have same result:

DECLARE @T1 TABLE (ID INT)

DECLARE...

i think you should first find out why someone would want to combine those two stored procs and base on that set some rules on what to do depending on...

1. You should be able to do all of it assuming the sql / agent account has the relevant access to the backup/restore folders.

2. If you have the relevant premissions...

Thats the closest i could get, I'm quite sure there's a better way of doing it but couldn't think of anything else ATM.

SELECT CONVERT(XML, '

<CustomerAccounts TransactionTimeStamp="2015-04-01T10:50:00Z" PageNumber="1" PageSize="500" EndOfFile="true" CreatedLanguage="EN">'...

you can use xp_cmdshell proc to run a command in command prompt.

EXEC xp_cmdshell 'bcp "SELECT * FROM database.dbo.table1" queryout "C:\Folder\TextFile.txt" -t, -c -S .\SQLEXPRESS -U user -P password'

you can use bcp command in command prompt or place the script in a batch file to do that i.e.:

bcp "select * from t1" queryout TextFile.txt -t, -c -S .\SQLINSTANCE...

it might be that the oledb destination task can not connect to destination and validate it. check your oledb connection in connection manager that is being used by this task...

Nice article to read on Monday morning.

Thanks Gail

Just be careful when using Ole DB Command as it processes a single row at a...

Check yourself what your substrings are returning. anyway this can be converted to datetime without any string operations:

SET DATEFORMAT mdy

;WITH CTE_BD

AS(

SELECT *

FROM (

SELECT '06/06/63' Col015 UNION ALL

SELECT '09/17/61' Col015 UNION...