Viewing 15 posts - 3,406 through 3,420 (of 5,109 total)
Without an expected output, butusing a previous post, this is a guess:SELECT DueDate,
ProductName, ProductDescription, ProductGroup,
SalesOrderNumber,
--FIRST_VALUE(QtyInStock)...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 7:29 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 7:17 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 6:48 am
The error message is telling you the problem here, the user/login the report is running under is being denied permission to select from the object "ServiceRequired" on the database "XXXXX". Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 6:39 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 5:47 am
As for the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 5:06 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 4:47 am
If you're simply changing the connection string from one server to the other, then double hopping won't be a problem. Your connection would be going directly to the other server...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 4:32 am
You can much more easily get the data out of your XML by using XQuery on your table. So the below would be used after you insert your data into...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 3:29 am
Personally, I find the easiest way is to insert the data into a staging table, and then use a MERGE statement, or a INSERT/UPDATE statement. SSIS does have tools to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 3:18 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 1, 2017 at 1:50 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 31, 2017 at 10:00 am
What have you tried so far? There could be a few answers to this, but it also depends on your data(for example, will it always only have a maximum of...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 31, 2017 at 9:12 am
Not much to go on, but perhaps:SELECT *,
CASE WHEN LongRunN2 IS NULL THEN NULL
ELSE (SELECT COUNT(*)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 31, 2017 at 8:32 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 31, 2017 at 8:25 am
Viewing 15 posts - 3,406 through 3,420 (of 5,109 total)