Viewing 15 posts - 31 through 45 (of 81 total)
June 13, 2018 at 7:44 pm
June 13, 2018 at 7:38 pm
May 3, 2018 at 11:04 pm
Nice one , that is a better and simple solution than mine.
May 3, 2018 at 10:50 pm
May 3, 2018 at 10:46 am
what i have done is to convert the records in userimport from columns as rows first.
ie (udf1, udf2, ...) is converted as
userid,fieldno,value
1 , 1 , New1
1...
May 2, 2018 at 11:26 am
For generating all dates between start and end dates you could do the following.
1. set up a cte that generates numbers from 1.. to a reasonably large value....
May 1, 2018 at 8:25 pm
Does having pipe cause problems in the xml creation? I didnt get any errors
Check, i have an entry such as Bright||&|Red Cup
http://sqlfiddle.com/#!18/7124e/135
Anyway, you would do...
April 29, 2018 at 11:03 am
Do you happen to have an id field on the level2 column. such as level2_id that you wish to order by
If you do then you can order by...
April 28, 2018 at 5:43 am
April 28, 2018 at 4:23 am
April 27, 2018 at 1:03 pm
Another option is to make use of an indexed view/materialized view to implement the logic(sum of all percentage to be > 100%) and have a unique clustered index on it.
April 26, 2018 at 8:34 pm
Just a small doubt.
----------
insert into table1 values
('A'),('B'),('C'),('D'),('E'),('F'),(' ');
----
I have...
April 26, 2018 at 5:08 am
Viewing 15 posts - 31 through 45 (of 81 total)