Viewing 15 posts - 16 through 30 (of 86 total)
In the connection manager properties at project level in the Information Service Catalogue,
We can set the Username and Password for each of the connections,
note the other thing we...
December 14, 2018 at 6:47 am
Thanks Phil,
That's pretty much how we did it, although we just passed the sensitive parameters in the project
configuration. Maybe I should use Environment Variables, but I've...
December 14, 2018 at 6:19 am
August 15, 2018 at 2:36 am
I twill work if you don't use two part naming convention but reference the correct Column in the Sub Query.
i.e.
April 3, 2018 at 12:52 am
Yeah,
It was the fact the first balance could possibly be null that was causing me the issue.
June 10, 2016 at 3:24 am
Perfect thanks
that was actually just a snapshot.
I used CTE when creating the balances table and left joined to the source.
I believe I've Included all the dates thanks
June 9, 2016 at 9:56 am
Hi Jez,
Thanks for the update it's given me a lot of food for thought.
I certainly wouldn't have considered the schema locking during the switch, something that I'm clearly going...
February 12, 2016 at 2:09 am
February 10, 2016 at 4:06 am
Hi
use MERGE with an OUTPUT clause into a temp table. MERGE will give you access to both the INSERTED and ORIGINAL ID's. You can force the condition to false so...
February 9, 2016 at 9:00 am
If I run EXEC spMyStoredProc I get two results:
387961
387962
OK So Run
DECLARE @ResultSet INT
EXEC @Resultset =spMyStoredProc
SELECT @ResultSet
and tell me what you get
February 5, 2016 at 9:14 am
To prove what Drew has just said,
can you just run
EXEC spMyStoredProc
and see what the result set is
February 5, 2016 at 9:07 am
@Results returns
387961
387962
No it doesn't,
Can you run the select @Results as I suggested and tell us the value.
I suspect it will be 0
February 5, 2016 at 9:04 am
Can You Tell me what the value of @Results is
by selecting it
DECALRE @Results INT
EXEC @Results = spMyStoredProc
SELECT @Results
IF @Results IS NOT NULL
PRINT 'Hello'
ELSE
PRINT 'OK thanks'
February 5, 2016 at 8:42 am
A stored Procedure will never return NULL
from msdn
[When used with a stored procedure, RETURN cannot return a null value. If a procedure tries to return a null value (for example,...
February 5, 2016 at 8:30 am
Hi Please refer to this Stairway for a more in depth look at CLR.
http://www.sqlservercentral.com/stairway/105855/.
The Hashbytes function is used to proved a method of detecting changes over
a row by...
December 7, 2015 at 7:54 am
Viewing 15 posts - 16 through 30 (of 86 total)