Viewing 15 posts - 31 through 45 (of 2,006 total)
:ermm: Did you even try?
ALTER PROCEDURE dbo.SP_CDB_EA2 @RiskRef VARCHAR(100)
AS
BEGIN
SET NOCOUNT ON;
--THIS IS A STATEMENT TERMINATOR, NOT A STATEMENT BEGININATOR!
--;
WITH ...
August 5, 2015 at 5:03 am
SQLRNNR (8/4/2015)
Cadavre (8/4/2015)
Again, not very clear what you want. . . maybe something like: -Look at that, getting lucky. 😀
"Why hasn't anyone killed him yet?"
"Dumb luck," Wit said. "In that...
August 4, 2015 at 8:53 am
Again, not very clear what you want. . . maybe something like: -
SELECT T.*,
CASE WHEN ACC_TYPE_CODE = '0001' THEN POST_NETT_AMT_DEL
...
August 4, 2015 at 8:21 am
Phil Parkin (8/4/2015)
Thanks for doing a proper analysis :blush:
I just found myself with a spare few minutes whilst trying to reproduce a customer issue in-house 😉
reddychaitanyakrishna (8/4/2015)
I tried your...
August 4, 2015 at 4:08 am
reddychaitanyakrishna (8/4/2015)
Hi Phil,Thanks for checking my query.
Can you please let me know where i need to do changes.
Thank you.
Many issues. . . comments inline.
CREATE PROCEDURE dbo.SP_CDB_EA2 @RiskRef VARCHAR(100)
--drop table #Tmp
AS
BEGIN
...
August 4, 2015 at 2:31 am
SQLRNNR (7/31/2015)
I like the idea of the siren. We used a howling monkey.And in other news ... you changed your profile pic.
A howling monkey has the benefit that it can...
August 3, 2015 at 5:21 am
Jeff Moden (8/2/2015)
What a total waste of time for the interviewers. Pork chops are not enough for these people whether they believe themselves to be innocent or not.
It depends...
August 3, 2015 at 5:08 am
Brandie Tarvin (7/30/2015)
Work...
July 31, 2015 at 8:46 am
I have a HP Microserver, with ESXi installed then a few VMs (domain controller on Windows Server 2008 R2, SQL Server 2014 on Windows Server 2012 R2 core, Ubuntu Core...
July 13, 2015 at 6:31 am
My home lab in on a HP Microserver, with ESXi installed then a few VMs. Haven't had any issues.
Before I got myself thee Microserver, I used to run OracleBox[/url]...
June 22, 2015 at 2:36 am
rajeshjaiswalraj (6/18/2015)
example : Database --> A , table is...
June 18, 2015 at 8:32 am
This looks like homework to me, so I'm not willing to give you the answer but I will try and help you arrive at it on your own.
DECLARE @TABLE AS...
June 17, 2015 at 1:45 am
Whenever I get a message or e-mail from a recruiter, I save their e-mail address in a group. When I'm looking for work, I send an e-mail to that...
June 12, 2015 at 7:44 am
Technically, I think that the fastest way to get rid of the unicode junk would be to cast it to VARCHAR. . . obviously this would remove any unicode data...
April 24, 2015 at 7:43 am
serg-52 (4/22/2015)
NCHAR(0x0020) which is binary dumped as 0x2000 is the only symbol with ASCII =32 and it's trimmed OK. All the rest have other ASCII.
Must be collation based,...
April 22, 2015 at 7:41 am
Viewing 15 posts - 31 through 45 (of 2,006 total)