Viewing 15 posts - 3,166 through 3,180 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 12, 2017 at 4:43 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 12, 2017 at 4:12 am
I might be missing something, but i can't see any kind of relationship between properties and opportunities. How do you know a property is applicable to a opportunity (and vice...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 12, 2017 at 4:00 am
First things first, is we need more detail. Secondly, let's start at the beginning, as resolving the first issue may resolve the rest. You state "Most of the databases are...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 11, 2017 at 9:46 am
Just an FYI at this point, but you are correct with regard to your...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 11, 2017 at 8:58 am
A CTE might work well here then. I've not used your above query, as I don't quite understand your goal, but this should put you on the right path: Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 11, 2017 at 8:52 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 11, 2017 at 6:02 am
Sounds like your process moving data from your staging table to your production table is just inserting all the data, it's not doing any checks for the existance. You'll need...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 11, 2017 at 3:58 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 11, 2017 at 2:24 am
SQL Server 2012 does not support SSIS: https://msdn.microsoft.com/en-gb/library/cc645993(v=sql.110).aspx#SSIS
You'll need to use Standard or above.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 11, 2017 at 2:15 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 8, 2017 at 12:49 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 8, 2017 at 12:35 pm
I assume, that this value is therefore stored as a varchar? Also, just to confirm, are you storing them as dd-M-yy (08-9-17) or dd-MMM-yy (08-Aug-17) (note M returns the Month...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 8, 2017 at 10:14 am
The sa account would link to the dbo user. the sa is the System administrator, and has the highest privileges available on the server. Part of that means that it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 8, 2017 at 9:41 am
I do not know why it is...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 8, 2017 at 9:01 am
Viewing 15 posts - 3,166 through 3,180 (of 5,109 total)