Viewing 15 posts - 3,031 through 3,045 (of 7,187 total)
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
September 18, 2015 at 5:19 am
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
September 11, 2015 at 9:06 am
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...
September 11, 2015 at 7:39 am
Right-click on the table name in SSMS, choose Script Table As and then choose the option that's right for you.
John
September 11, 2015 at 5:57 am
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,...
September 11, 2015 at 2:38 am
pietlinden (9/10/2015)
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....
September 11, 2015 at 2:22 am
lawrence.simpson (9/10/2015)
If I understand you correctly though, wrapping Treatmentdate in a MAX would only give me the last date.
Not sure whether I'm missing something here, but why not use MIN...
September 10, 2015 at 9:19 am
Have you checked the properties of the publication to verify that the two tables are included as articles in the publication?
John
September 10, 2015 at 8:58 am
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...
September 10, 2015 at 8:55 am
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...
September 10, 2015 at 5:09 am
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...
September 10, 2015 at 3:53 am
In that case, I think Lowell's solution nails it!
John
September 9, 2015 at 7:08 am
What would be your expected result set from these rows?
1 1
2 1
3 0
1 0
2 1
3 0
3 1
John
September 9, 2015 at 6:00 am
In that case, there's absolutely no reason I can see to use a maintenance plan for this. Please try changing the job step to T-SQL and see whether that...
September 9, 2015 at 5:10 am
Why are you using a maintenance plan for this? Maintenance plans are what their name suggests - for backups, updating statistics, consistency checks and so on.
The query in your...
September 9, 2015 at 4:08 am
Viewing 15 posts - 3,031 through 3,045 (of 7,187 total)