Viewing 15 posts - 181 through 195 (of 7,168 total)
Comments are most useful when they comminicate intent as opposed to structure. No need to rewrite Chapter 1 of every "how to write T-SQL" book alongside your code. However, you[\i]...
February 21, 2016 at 1:10 pm
etl2016 (2/21/2016)
I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.
Could you please suggest if 8GB RAM and Core...
February 21, 2016 at 12:17 pm
kshah82 (2/21/2016)
February 21, 2016 at 7:48 am
kshah82 (2/20/2016)
Thanks for the response!Sorry my bad, Badge ID is he Employee ID.
Take these two rows:
INSERT dbo.Source2(EmployeeID, ClerkID) Values(123456, 'abcd');
INSERT dbo.Target2(EmployeeID, AssetValue) VALUES(123456, 'abcd');
yes, no update
OK, got it.
INSERT...
February 20, 2016 at 10:04 pm
assefamisganaw (2/20/2016)
Now I want to execute query from Server1 and write to Server2.
I have two physically separated machine installed with the...
February 20, 2016 at 12:37 pm
TomThomson (2/20/2016)
Ed Wagner (2/19/2016)
TomThomson (2/19/2016)
ZZartin (2/19/2016)
Driverroad hog
Harley
Davidson
Curry
February 20, 2016 at 11:15 am
JRoughgarden (2/19/2016)
R Barry Young's procedure fails if any databases have conflicting collations. Report Server databases have Latin1_General_CI_AS_KS_WS collations, whereas the default collation is often SQL_Latin1_General_CP1_CI_AS.
OK, so can you post the...
February 20, 2016 at 8:30 am
ramana3327 (2/19/2016)
I am working on creating alert for db status when there is any change except online for all databases
I tested using if @state = 'Online' but it didn't give...
February 20, 2016 at 8:16 am
kshah82 (2/20/2016)
if the Badge IDs and Asset Value and Clerk IDs match then no action.
if the Badge IDs match and Asset Value...
February 20, 2016 at 8:11 am
As I understand it, this code is never even executed so your TRY/CATCH is not even considered. During the early stages of execution the QO is evaluating the possibility of...
February 20, 2016 at 7:56 am
Phil Parkin (2/19/2016)
I think that you can do it using catalog.set_execution_property_override_value.
Good call. You can.
I remember now..I explicitly went towards promoting everything we used to set on the dtexec command line...
February 19, 2016 at 2:51 pm
After posting this new thread I went in and the Topic Options are in fact "No Email Notification (Just Add To List)". Did I accidentally change a default option somewhere?
February 19, 2016 at 6:42 am
It's been over a year since I looked into this but during a migration from 2008 R2 Package Deployment model to 2012 Project Deployment model I seem to remember having...
February 18, 2016 at 9:31 pm
Jeff Moden (2/18/2016)
Gstar1224 (2/18/2016)
...calculate the number of concurrent users every hour...
What does that actually mean? Do you mean, for example, if someone were logged in from 1:30AM until...
February 18, 2016 at 9:05 pm
WITH cte AS (SELECT DOCTOR, PATIENT, [DATE OF VISIT], [TIME OF VISIT],
LEAD(PATIENT, 1,...
February 18, 2016 at 7:10 pm
Viewing 15 posts - 181 through 195 (of 7,168 total)