Viewing 15 posts - 7,066 through 7,080 (of 13,876 total)
komal145 (6/10/2016)
need lowerbound :12 and upperbound:24
Right now I wrote expression in tsql something like below:
Substring([AgeBucket],0,CharIndex('-', [AgeBucket])) As LowerBound
,LTRIM(REPLACE(Substring([AgeBucket],CharIndex('-', [AgeBucket]),3),'-','')) As UpperBound
How can we re-write...
June 10, 2016 at 12:16 pm
komal145 (6/10/2016)
June 10, 2016 at 12:11 pm
etl2016 (6/9/2016)
We use ROW_NUMBER () to partition results and hand-pick the needed records, mostly to address duplicate records scenario.
However, how do we sense that there is a potential threat...
June 9, 2016 at 8:47 am
Try
Case when LogDate = cast(LogDate as date) ...
June 8, 2016 at 6:16 pm
Lynn Pettis (6/8/2016)
Brandie Tarvin (6/8/2016)
User asks me to move this bit of code into QA:
ALTER TABLE MyTable
ADD Col1 INT,
Col2 INT
GO
I push back and say "Please add...
June 8, 2016 at 12:31 pm
Response removed as a result of the change from 'rows' to 'columns'!
June 8, 2016 at 12:07 pm
kokilaeb (6/8/2016)
There is no forum for oracle discussion.
Really? So what is this?
https://community.oracle.com/community/database/developer-tools/sql_and_pl_sql
June 8, 2016 at 10:36 am
OK. Next step is to remove the WHERE conditions one by one and rerun. Hopefully, removing one of the conditions will make rows appear ... then we can focus troubleshooting...
June 8, 2016 at 7:43 am
This is difficult, because we don't know what your data looks like. But first of all, here is your query again, reformatted for readability:
SELECT CustomerAccount.AccountNumber
, ...
June 8, 2016 at 6:14 am
Snargables (6/8/2016)
What about querries? Should the same logic apply? It's been my experience...
June 8, 2016 at 6:02 am
GilaMonster (6/7/2016)
Luis Cazares (6/7/2016)
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That's...
June 7, 2016 at 3:22 pm
Yes, but ...
I'd suggest trying out a couple of non-destructive queries first ... and definitely in a test environment ... just to get familiar with it.
Note the comments about sp_msForeachDB...
June 7, 2016 at 1:37 pm
Some pratting about is required to handle the single quotes embedded in your SQL, before it can be passed to an executor proc.
One way is to replace all single quotes...
June 7, 2016 at 12:58 pm
Viewing 15 posts - 7,066 through 7,080 (of 13,876 total)