Viewing 15 posts - 2,911 through 2,925 (of 4,820 total)
This is clearly an Oracle table creation statement. Given that the values coming from Oracle will be character-based, I'd strongly recommend that the data transfer to SQL Server be done...
February 10, 2017 at 1:34 pm
I have this table
CREATE TABLE [dbo].[students](
[id] [int] NOT NULL,
[studentusa] [int] NULL,
[studentuk] [int] NULL,
[courseid] [int]...
February 10, 2017 at 12:51 pm
PSB - Thursday, February 9, 2017 5:44 AMThe numbers are not coming in correctly .
I don't see a clear, concise, and OBVIOUS...
February 10, 2017 at 12:29 pm
Many thanks for the pointers. I had a look at NTILE...
February 10, 2017 at 12:02 pm
How about this:
SELECT CAST(IX.[DateTime] AS date) AS [Date], IX.Invoice_Number, IX.ItemNum, I.ItemName, IX.Reason_Code, IX.LineNum,
IX.Amount, IX.Quantity, SUM(IX.Amount * IX.Quantity) AS Voided_Total, IT.Payment_Method
FROM Invoice_Exceptions AS IX
INNER...
February 10, 2017 at 8:57 am
I started looking at this before all the other solutions got posted, and I'm pretty sure the code I came up with is ugly, but I'd actually like to know...
January 26, 2017 at 1:52 pm
January 26, 2017 at 6:55 am
i have daily job which copies data from production to uat.i want to know...
January 25, 2017 at 12:22 pm
I'm dealing with a database problem and I would like to know how to solve...
January 20, 2017 at 7:02 am
The original poster said something about a "new login". If there's any logic in the app that uses any kind of SID identifier for a given login, and there are...
January 19, 2017 at 3:02 pm
January 19, 2017 at 2:45 pm
January 19, 2017 at 1:45 pm
SELECT CHARINDEX('A2,C1,C2,C3,D1', '01,02,03,04,05,A1,A2,C1,C2,C3,D1,D2,
J1,J2,J3,K1,M1,M2,M3,N1,N2,N3,P1,P2,P3,R1,S1,S2,T1,T2,T3,W1,W2,W3') AS [Location]
Location
19
SELECT CHARINDEX('A2,R1,T3,D1', '01,02,03,04,05,A1,A2,C1,C2,C3,D1,D2,
J1,J2,J3,K1,M1,M2,M3,N1,N2,N3,P1,P2,P3,R1,S1,S2,T1,T2,T3,W1,W2,W3') AS [Location]
Location
0
Why A2,R1,T3,D1 return 0? A2,R1,T3,D1 is...
January 19, 2017 at 1:12 pm
January 19, 2017 at 12:33 pm
January 18, 2017 at 5:29 pm
Viewing 15 posts - 2,911 through 2,925 (of 4,820 total)