Viewing 15 posts - 4,291 through 4,305 (of 8,753 total)
SQLRNNR (11/6/2015)
The datetime is stored as milliseconds right? From some ambiguous epoch right?
Ehemm, cough cough cough!
😎
November 6, 2015 at 10:16 am
WayneS (11/6/2015)
xsevensinzx (11/6/2015)
who in the hell is applying for a senior position and not know GETDATE()?Just 9 out of 10 applicants. Maybe higher.
That is just being spammed with non-applicable...
November 6, 2015 at 10:13 am
Igor Micev (11/6/2015)
Igor Micev (11/6/2015)
DonlSimpson (11/5/2015)
Ed Wagner (11/5/2015)
djj (11/5/2015)
crookj (11/5/2015)
Igor Micev (11/5/2015)
Luis Cazares (11/5/2015)
anthony.green (11/5/2015)
Igor Micev (11/5/2015)
crookj (11/5/2015)
Ed Wagner (11/5/2015)
anthony.green (11/5/2015)
TomThomson (11/4/2015)
DonlSimpson (11/4/2015)
Weakfrail
Old
Experience
Familiarity
Information
Announcement
Billboard
City
of Heroes
Advengers
Hiro Nakumura
Hiroshima
Bomb
End
TRY
November 6, 2015 at 1:31 am
Raghavender (11/6/2015)
I am trying to attach a database. But I am receiving below error:
Unable to open the physical file "D:\databasepc.mdf". Operating system error 5: "5(Access is denied.)".
I have added...
November 6, 2015 at 1:30 am
jigging.tech (11/5/2015)
Currently, in the new environment I'm working in, there are no stored procedures everything comes in as Ad-Hoc T-SQL with local variables.
I brought up that we...
November 6, 2015 at 12:04 am
Grant Fritchey (11/5/2015)
BWFC (11/5/2015)
I mentioned the Excel BI tools and apparently they don't want use 'spreadsheets'. I'm pretty sure though that's down to a lack of understanding of the...
November 5, 2015 at 10:05 pm
You have to select / expand the toolbox
😎
November 5, 2015 at 9:57 pm
Brandie Tarvin (11/4/2015)
djj (11/4/2015)
I also interview really badly.
Bridge Guardian: What is your name?
DJJ: Umm. I don't know?
DJJ: AGGGGHHHHH!
Bridge Guardian: Sigh. Usually they get to the swallow question before they go...
November 4, 2015 at 2:03 pm
Piling on further, now 23 posts into this thread and yet there are nowhere near enough information to even begin to guess let alone advice on the problem. Few facts...
November 4, 2015 at 9:32 am
Junglee_George (11/4/2015)
Thank You Eirikur.. Loved it..One more help. Is it feasible for this value to be shown
INSERT INTO #ActivityComments VALUES('S14-04932-01 + S15-04931-01 + S14-04932-02')
Output
----------
S14-04932-01, S15-04931-01, S14-04932-02'
That's an entirely different...
November 4, 2015 at 1:03 am
Quick fix
😎
CREATE TABLE #ActivityComments(Comments NVARCHAR(MAX))
INSERT INTO #ActivityComments VALUES('This is the study code for Field Phase S14-04932-01')
INSERT INTO #ActivityComments VALUES('Phase reporting has the study S15-04931-01 which is obselete')
INSERT INTO #ActivityComments VALUES('Phase...
November 4, 2015 at 12:38 am
Quick solution
😎
USE tempdb;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.customer_payment') IS NOT NULL DROP TABLE dbo.customer_payment;
IF OBJECT_ID(N'dbo.customer_info') IS NOT NULL DROP TABLE dbo.customer_info;
CREATE TABLE dbo.customer_payment
(
Customer_Nbr_TxtVARCHAR(255),
Loan_NbrBIGINT,
Trans_Amt decimal(22,2),
Payment_tp VARCHAR(255)
);
INSERT INTO dbo.customer_payment (Customer_Nbr_Txt,Loan_Nbr,Trans_Amt,Payment_tp)
VALUES
('007849', '11613577', '1000','ACH'),
('007849', '11613578', '200',...
November 3, 2015 at 10:27 pm
Further on Gail's excellent answer, can you post the actual execution plan and preferably the DDL (create scripts) for all tables, functions and indices?
😎
First glance at the code suggests that...
November 3, 2015 at 2:01 pm
Further on Jacob's excellent suggestion, check for the existence of the pattern before the substring, as you could have false positives when the pattern is not found.
😎
November 3, 2015 at 1:15 pm
GilaMonster (11/3/2015)
ChrisM@Work (11/3/2015)
Any folks out there with a little time to spare with this thread - it's just exceeded my comfort zone. Thanks.
No spare time this week, but given the...
November 3, 2015 at 11:54 am
Viewing 15 posts - 4,291 through 4,305 (of 8,753 total)