Have you tried using Powershell? Build the command with an expression, then use an Execute Process task to run it.

John

Don't use recursive CTEs to generate number sequences. You can only have a maximum of 32,767 numbers, and it's less efficient than the CROSS JOIN method. The recursive...

Use an Execute SQL task to get the list of reports, then loop through the list and use an Execute Process task to run each script.

John

Are you familiar with SSIS (Integration Services)? If so, it might be worth creating a package to do this. If not, it's fairly simple to loop through your...

Like many techniques, it has its place, although some may say it is somewhat overused. This is a very good introduction to the topic.

John

Is it as simple as this?

UPDATE dbo.Test

SET Denominator = (

SELECT Numerator

FROM Test t2

WHERE t2.MeasureID = 'c001'

AND t2.GroupID = 'A'

)

WHERE MeasureID = 'C010'

AND GroupID = 'A'

John

If the plug-in you are using doesn't provide any similar functionality, you could do [font="Courier New"]sp_help 'MyTable'[/font]. That wouldn't generate the DDL, but it would provide enough information to...

Right-click on the table name in SSMS, choose Script Table As and then choose the option that's right for you.

John

What type of replication are you using? How frequently does it run? What do you mean when you say the tables are not being applied - not created,...

pietlinden (9/10/2015)

---

John,

It's a recruiter, which makes me wonder, because the number of recruiters in this town that understand and can evaluate the "goodness" of T-SQL code is less than 5....

Not sure whether I'm missing something here, but why not use MIN...

Have you checked the properties of the publication to verify that the two tables are included as articles in the publication?

John

The query you posted isn't syntactically correct. Is this SQL Server or some other RDBMS, or are you just posting pseudo-code?

Anyway, if I understand correctly, all you need to...

Yes, of course. Select the Execute Process Task and press F4 to display the Properties window. Click on the ellipsis button next to Expressions. Choose WorkingDirectory from...

Pieter

Are you out of work, in work and looking, or in work and considering offered opportunities? If, like me, you're in the last of those categories, I wouldn't send...