Viewing 15 posts - 811 through 825 (of 1,229 total)
CELKO (12/19/2014)
We are migrating data from old DB2 systems to sql server 2012, the DATE FORMAT in those systems is in decimal format with 7 digits. CYYMMDD format. I...
December 19, 2014 at 11:30 am
Orlando Colamatteo (12/17/2014)
Just for the record, CHAR(253) is not Unicode.
Hi Orlando,
Hmm, I guess I am not clear on what you mean... I just saw that unicode decimal 253 is the...
December 18, 2014 at 2:29 pm
Agreed, its not hard on my eyes either. I am trying to get into the mind of someone that has not seen this syntax before. It is not that difficult...
December 18, 2014 at 2:16 pm
jshuter (12/17/2014)
I'd still do something like the following
declare @i int =...
December 18, 2014 at 11:50 am
Under SSMS> Server Objects, >
there is a Backup Devices folder. Here you can easily create a .bak file and easily find it later as well through here. You can point...
December 18, 2014 at 11:37 am
Statistically speaking you want the first quartile, so borrowing on Matt's solution I would just shift a few things to make it intuitive ...
with MYcte as (
selectMAINGROUP,vALUE, NTILE(4) OVER...
December 18, 2014 at 11:12 am
I find in these situation I save a lot of time by dropping the source and creating a new one. If I had SQL coded I copy it ahead of...
December 17, 2014 at 12:07 pm
0 means 0 , NULL means unknown. They are not the same.
One approach if you do not want to have nulls in your table is to have a "magic"...
December 17, 2014 at 11:46 am
mitesh.temre (12/17/2014)
lvbntapasvi (9/6/2014)
I am new to SSIS, and have started using it from the past 3 weeks. I have a task where in I am supposed to access the...
December 17, 2014 at 11:33 am
Luis Cazares (12/9/2014)
Should I insist on this method? I just added a NULLIF function and it works.
SELECT CAST( CAST( 19000000 + NULLIF(oldDate, 0) AS CHAR(8)) AS date)
FROM( VALUES('0980412'),('1100323'), ('0'))x(oldDate)
I think...
December 16, 2014 at 5:20 pm
I know this probably is a long shot but is everything lined up in the Sql Server Configuration Manager ? (I have shared memory, tcp/ip, and named pipes all enabled).
December 16, 2014 at 4:20 pm
MMartin1 (12/1/2014)
December 16, 2014 at 4:05 pm
Eirikur Eiriksson (12/16/2014)
DonlSimpson (12/16/2014)
MMartin1 (12/16/2014)
NULLIF((EVT.VAL2), 0)
Maybe I'm just missing something here, but how can the above EVER return a zero?
It would not, but that is what the user wanted. That...
December 16, 2014 at 2:45 pm
NULLIF((EVT.VAL2), 0)
Maybe I'm just missing something here, but how can the above EVER return a zero?
It would not, but that is what the user wanted. That is to prevent a...
December 16, 2014 at 11:29 am
As long as the business users understand the calculation and they are fine with it, that is what matters. Ideally if there are values missing I like to return null...
December 15, 2014 at 10:43 pm
Viewing 15 posts - 811 through 825 (of 1,229 total)